Thursday, January 3, 2013 1:13 PM
xmldeveloper
Question: How can I see programmatically the rights on a stored procedure?
Starting with SQL Server 2005, the sys.fn_my_permissions function can be used.
It has a quite simple syntax:
fn_my_permissions ( securable , 'securable_class')To answer the question, the code would be:
1 2 3 | USE MyDatabase; GO SELECT * FROM fn_my_permissions ('myStoredProcedure', 'OBJECT'); |