Getting Stored Procedure Permission details in Sql Server.

Vishalneeraj-24503
Posted by Vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 170
select U.name,
O.name,
permission_name
from
sys.database_permissions
join sys.sysusers U on grantee_principal_id = uid
join sys.sysobjects O on major_id = id
where O.name like 'sp_name'
order by U.name;

Comments or Responses

Login to post response