Merge grants (or similar)
Here is the issue we are having.
Two developers are working on different instances of the same database schema. If both of them add grants to the same user or role to different objects an issue arises when trying to commit to the repository.
The user that commits second will have a conflict.
If they choose the repository's grants for that user, they will lose their changes on their instance.
It they choose the database's grants for that user, they will overwrite the other user's changes in the repository.
It would be really nice to have one of these options when dealing with grants:
1) Treat grants as an attribute of the schema object.
2) Be able to merge grants
3) Be able to choose individual grants to bring across, and not revoke any.
What a terrible subject line. I would like to be able to edit that!