Get the list of permissions of database object

,

sp_helprotect is the system stored procedure used to determine the user level permissions of database objects including tables, stored procedures, user fenide functions, etc.

It displays the users who can access to database object, who granded the permission, type of permission, owner of hte objects, etc.

-- 	List all user permissions of all Database objects
	sp_helprotect					  

-- 	List all user permissions of tblSalary
	sp_helprotect 'dbo.tblSalary'	  

-- 	List all user permissions of sp_Get_Salary
	sp_helprotect 'dbo.sp_Get_Salary' 

-- 	List all user permissions of sp_Get_Salary
	sp_helprotect 'dbo.sp_Get_Salary', 'emp_user' 

-- 	List all user permissions of sp_Get_Salary provided by dbo
	sp_helprotect 'dbo.sp_Get_Salary', null,'dbo'

-- 	List all Object type user permissions
	sp_helprotect null, null,null,'o'

-- 	List all statement type user permissions 
	sp_helprotect null, null,null,'s'

Rate

4.06 (17)

Share

Share

Rate

4.06 (17)