Use sp_helprotect to return permissions information about a specified table.
To see permissions on the sales table, enter:
sp_tables sales
grantor grantee type action object column predicate grantable------- ------ ----- ------ -------- ------ ------- ------- dbo guest Grant Delete sales All NULL FALSE dbo guest Grant Delete Statistics sales All NULL FALSE dbo guest Grant Insert sales All NULL FALSE dbo guest Grant References sales All NULL FALSE dbo guest Grant Transfer Table sales All NULL FALSE dbo guest Grant Transfer Table sales All NULL FALSE dbo guest Grant Update sales All NULL FALSE dbo guest Grant Update Statistics sales All NULL FALSE dbo public Grant Select sales All NULL FALSE (1 row affected) (return status = 0)
For more information about the output of sp_helprotect, see the Reference Manual: Procedures.
