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
 Transact-SQL (2000)
 Object-Level Permissions

Author  Topic 

ggarza75
Yak Posting Veteran

50 Posts

Posted - 2008-10-07 : 17:30:54
Dont know if I'm wording this right, but hope this makes sense.

What the correct syntax to view all the object-level permissions to a certain database?

Thanks.

ggarza75
Yak Posting Veteran

50 Posts

Posted - 2008-10-07 : 17:38:33
No worries. I figured it out.
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-10-07 : 17:38:42
quote:
Originally posted by ggarza75

Dont know if I'm wording this right, but hope this makes sense.

What the correct syntax to view all the object-level permissions to a certain database?

Thanks.



sp_helprotect
Go to Top of Page

ggarza75
Yak Posting Veteran

50 Posts

Posted - 2008-10-07 : 17:52:58
quote:
Originally posted by sodeep

quote:
Originally posted by ggarza75

Dont know if I'm wording this right, but hope this makes sense.

What the correct syntax to view all the object-level permissions to a certain database?

Thanks.



sp_helprotect



Thats the one I got. Thanks anyways.
Go to Top of Page
   

- Advertisement -