View Permissions in SQL Server

Step I: List all dbo Grantor Permissions

EXEC sp_helprotect NULL, NULL, dbo
EXEC sp_helprotect @grantorname = 'dbo'

Step II: Listing the permissions for a table

EXEC sp_helprotect 't_register'


Step III: Listing the permissions granted by a specific user

EXEC sp_helprotect NULL, 'Linda'

Step IV: Listing the statement permissions only

EXEC sp_helprotect NULL, NULL, NULL, 's'