Permissions in 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

Transact-SQL (2000)

Permissions in a table

Author

Topic

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2007-04-20 : 11:06:21

Gurus
In a particular table i need to find out that which user has got what all permissions
How can i do this
Please help
Regards
Nitin

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-04-20 : 11:10:32

[code]use pubs

-- one table
exec sp_helprotect 'authors'

-- all objects
exec sp_helprotect[/code]

CODO ERGO SUM

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2007-04-20 : 11:27:02

Thanks a ton Michael

Regards

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources