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

Knalstad 1 Reputation point
2020-08-26T13:06:21.373+00:00

Hi

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?

Thx

/Fredrik

Azure SQL Database
{count} votes