QuestionQ34

VerifiedData Protection

Which ordered sequence of object privileges should be granted so that a custom role has read-only access to a table?

Drag & Drop
First
Second
Third
Explanation

A role needs USAGE on a database and on its schema to access objects contained there. SELECT on the table then grants read-only querying without data-modification privileges.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!