What are the challenges you face when working across database platforms? Take the survey
Options

Permission Comparison

WorksTGWorksTG Posts: 2
edited April 4, 2006 12:56PM in SQL Compare Previous Versions
I would like to be able to compare and script just the permissions and groups between objects, nothing else.

Is this possible?

When I use the "Options" to Ignore as much as possible, the resulting scripts still have more contained in them than just the groups and permissions. Can the product do this or will I need to manually cut out the group and permission differences?

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello,

    User and role memberships can be scripted on their own -- but object permissions such as GRANT, SELECT, and UPDATE are attributes of the table, view, or procedure and can't be scripted independently.
Sign In or Register to comment.