M msp Registered User. Local time Today, 06:38 Joined Apr 5, 2004 Messages 155 Sep 25, 2006 #1 Hi is anyone aware of a query or Stored Procedure I can call that will retrieve all the users and permissions for a particular database. Thanks for any help.
Hi is anyone aware of a query or Stored Procedure I can call that will retrieve all the users and permissions for a particular database. Thanks for any help.
SQL_Hell SQL Server DBA Local time Today, 06:38 Joined Dec 4, 2003 Messages 1,361 Sep 25, 2006 #2 Hi there try this exec sp_helplogins or this select * from sysusers