Azure SQL DB | GRANT VIEW DEFINITION to sys.database_role_members?

Knalstad 1 Reputation point


Trying to enable view definition on sys.database_role_members

Running this query:

GRANT VIEW DEFINITION ON OBJECT::sys.database_role_members TO [user].

Get the following error:
Granted or revoked privilege VIEW DEFINITION is not compatible with object.

Works fine on other non sys tables. Want to enable user access to view metadata on sql sys.database_role_members view.

Any Idea?



Azure SQL Database
{count} votes