Permission Comparison
WorksTG
Posts: 2
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?
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
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.