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)
 How to determine what tables a user is denied.

Author  Topic 

homersdonut
Starting Member

1 Post

Posted - 2009-02-04 : 10:33:19
I am trying identify which talbes a user is denied access in our SQL 2000 SP4 Db.

This seems like a relatively simple task but I am having some challenges getting this information.

Any suggestions would be appreciated

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-04 : 10:45:01
Use sp_helprotect.
Go to Top of Page
   

- Advertisement -