0 votes
1 view
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 (38.4k points)

Try to use this, should work:

sp_helprotect "table name" go

Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...