fatehullahbaigmirza
SSC Veteran
Points: 232
More actions
October 27, 2013 at 10:21 am
#395729
Hi i am using mssql 2008 r2 and i want to list the permissions on the stored procedures of master database ,How to get it by a script
October 29, 2013 at 6:23 am
#1662316
SELECT * FROM sys.database_permissions WHERE major_id = OBJECT_ID('store_procedure_name')
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply