check permission on a table - SQL Server Forums

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 Development (2000)

check permission on a table

Author

Topic

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2008-07-08 : 10:16:49

how can i get,using code , all the persmissions of a table
including a grant/deny permisson on a certin column on a table?

thnaks in advance
peleg

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-08 : 13:26:04

Have a look at syspermissions system table.

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2008-07-08 : 13:58:36

and this:
exec sp_helprotect '<tableName>'

Be One with the Optimizer
TG

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2008-07-08 : 16:28:05

TG - thnaks the table is ver clear
visakh16 - where can i get moore dat on the column of the table u gave me?
thnaks i nadvance
peleg

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-08 : 23:15:57

Books online lists columns of system tables, just search by table name.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources