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
 General SQL Server Forums
 New to SQL Server Programming
 Security Cleanup

Author  Topic 

munkdogg
Yak Posting Veteran

53 Posts

Posted - 2008-12-03 : 11:33:09
I am purging some (very!) historical SQL server logins. How can I determine in SQL2K which objects this user may own?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-03 : 11:57:27
See sp_helprotect and sp_helplogins.
Go to Top of Page

munkdogg
Yak Posting Veteran

53 Posts

Posted - 2008-12-03 : 12:15:06
quote:
Originally posted by sodeep

See sp_helprotect and sp_helplogins.



Wunderbar. Thank you!
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-03 : 13:27:59
Cool .
Go to Top of Page
   

- Advertisement -