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 2005 Forums
 Transact-SQL (2005)
 query user permissions

Author  Topic 

eevans
Starting Member

48 Posts

Posted - 2009-06-05 : 10:34:35
Hello,
Is it possible to write a query to display users who have update permissions for a given table?

Thanks!

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2009-06-05 : 10:43:02
try this:
exec sp_helprotect @name = '<tableName>'

Be One with the Optimizer
TG
Go to Top of Page

eevans
Starting Member

48 Posts

Posted - 2009-06-05 : 13:15:09
Thanks TG.
Go to Top of Page
   

- Advertisement -