I need to compare the permissions for a specific user between two databases
for views, tables, and stored procedures, to make sure that they are the
same.
If I could just figure out how to extract the data from each database, I
don't mind a certain level of manual comparison in Excel.
I have been digging around the syspermissions table, but can't find the
access level that has been granted/denied.
Any suggestions?
Thanks!Look up the PERMISSIONS function in SQL Server Books Online. It returns a
bitmap which can be massaged in t-SQL to retreive the object/statement
permissions.
Anith
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment