User permission Query

msp

Registered User.
Local time
Today, 06:38
Joined
Apr 5, 2004
Messages
155
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 there

try this

exec sp_helplogins


or this

select * from sysusers
 

Users who are viewing this thread

Back
Top Bottom