sp_helprotect

The new option, permission_name, in sp_helprotect provides information (grantor name, grantee name, table/column name, and grantability) for any specific permission granted in a given database. The syntax is:

sp_helprotect [name [, username [, "grant" 
	[,"none"|"granted"|"enabled"|role_name [,permission_name]]]]] 

permission_name can be any value from the sysprotect.action column.