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 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?
To centralize grant management and maximize security while allowing a user to have OWNERSHIP on a table without the ability to make grant decisions, the correct approach is to add the WITH MANAGED ACCESS parameter on the schema. This parameter ensures that the ownership rights are managed centrally and the user will not have the ability to make grant decisions.
D is correct. The owner of the table won't be able to grant access to other roles etc