Wednesday, March 7, 2012

permission to execution stored procedure

Hi, how can i know with t-sql command who has permission to execute
stored procedure?(imss@.netvision.net.il) writes:
> Hi, how can i know with t-sql command who has permission to execute
> stored procedure?
sp_helprotect <procedure>
If you are on SQL 2005 there are other options as well.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

No comments:

Post a Comment