I agree to Idea Add the option 'compare granted privileges' to 'compare schema'
Voting Disabled

24 votes

I disagree to Idea Add the option 'compare granted privileges' to 'compare schema'

Rank37

Idea#250

This idea is active.
Utilities »

Add the option 'compare granted privileges' to 'compare schema'

While doing a 'compare schema',across 2 databases, currently only privileges assigned by a user are listed, not privileges assigned to a user. It would be nice to have a feature that compares privileges assigned to a user, as currently the only alternative is to do this is do perform a full database compare.

Submitted by jan.geldof 3 years ago

Comments (4)

  1. Hi. Mr/Miss Jan. I think that's a bug. 'compare schema' should compare privileges assigned to a user at anytime. An option is not necessary because those options mostly about Which kind of Object types choose to compare.

    3 years ago
    0 Agreed
    0 Disagreed
  2. jan.geldof Idea Submitter

    Hi Aimee,

    Toad regards this behaviour 'as not a bug'. I sent a bug report about the missing information returned by 'Compare Schema' to Toad and they stated that it is by design that 'Compare Schema' only shows the grants granted by the user.

    3 years ago
    0 Agreed
    0 Disagreed
  3. Moderator

    You can right-click on a user in the schema browser and choose "compare with another object" to compare privileges granted to the user.

    3 years ago
    0 Agreed
    0 Disagreed
  4. jan.geldof Idea Submitter

    You are right, it is possible to list the differences in granted privileges like this, but it would still be nice to also list them with 'Compare Schema'

    3 years ago
    0 Agreed
    0 Disagreed