A Data Engineer wants to centralize grant management to maximize security. A user needs OWNERSHIP on a table in a new schema. However, this user should not have the ability to make grant decisions. What is the correct way to do this?
A.
Grant OWNERSHIP to the user on the table.
B.
Revoke grant decisions from the user on the table.
C.
Revoke grant decisions from the user on the schema.
D.
Add the WITH MANAGED ACCESS parameter on the schema.
D is correct. The owner of the table won't be able to grant access to other roles etc
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
stopthisnow
1 month, 1 week ago