list of users and roles that have permissions to an object (table) in SQL

Question

You'd think I'd be able to Google such a simple question. But no matter what I try, I hit a brick wall.

What is the TSQL statement to find a list of roles that have permissions to a table?

The pseudo-code looks like this:

SELECT role_name 

FROM permissions 

where object_name = 'the_table_i_need_to_know_about'

Answer 1

Try to use this, should work:

sp_helprotect "table name" go