Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Query to find out login roles

Author  Topic 

waxdart23
Starting Member

33 Posts

Posted - 2006-01-16 : 09:36:15
Is there a query that I can give to someone that will details the database roles etc of a given database login?

Thanks
Paul

Thanks
P

mcrowley
Aged Yak Warrior

771 Posts

Posted - 2006-01-16 : 13:00:01
Use sp_helpuser. That will give you all the roles a user is a member of.
Go to Top of Page
   

- Advertisement -