Show all permissions on a database for a particular user

• 

  gsuttie wrote:

  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

  
  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

  Andras B November 16, 2007 08:47

  - 0 +

Add comment

Please sign in to leave a comment.