Explore Courses Blog Tutorials Interview Questions
0 votes
in Azure by (16.8k points)
edited by

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'

1 Answer

0 votes
by (45.3k points)

Try to use this, should work:

sp_helprotect "table name" go

Browse Categories