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)
 permission

Author  Topic 

vicki
Posting Yak Master

117 Posts

Posted - 2002-04-16 : 14:31:45
Hi,

Is there any command out there to find out who have the access in this DB and what kind the permission they have?

Thanks

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-04-16 : 16:55:30
You should look at the sp_helprotect system procedure in Books Online, I think it will do what you want.

Go to Top of Page
   

- Advertisement -