Show all permissions on a database for a particular user
gsuttie
Posts: 80
Hi Folks
What tool would I use to find out what execute permission UserA has on the database stored procs?
Is there a tool I can use to select a user and see what rights they have at every level?
Cheers
Gregor
What tool would I use to find out what execute permission UserA has on the database stored procs?
Is there a tool I can use to select a user and see what rights they have at every level?
Cheers
Gregor
Comments
Hi Gregor,
If you are looking for the effective permissions, i.e. that consider the role membership of a user, and the permissions assigned to both the roles and the users, then you could use Microsoft's Management Studio. In the Object Explorer find the user, select properties, Securables, Effective Permissions.
SQL Compare can show you the database level permissions for users, however object level permissions, following Microsoft's format of script creation, are shown with the database objects.
Regards,
Andras
Red Gate Software Ltd.