How can we improve our Oracle tools?

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.

4 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    brianliebbrianlieb shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base