Data Governance

[Harikrish]

If I grant all privileges in my schema does that automatically give access to users for all underlying objects? Or should I give access seperately for all the objects?

[Alberto_Umana · Accepted solution]

Hi @Harikrish,

In Unity Catalog, privileges are hierarchical and inherited downward. This means that granting a privilege on a catalog or schema automatically grants the privilege to all current and future objects within the catalog or schema.

Therefore if give all privileges in your schema all objects within that will be granted access to whoever you are giving all privileges in the schema.

[Harikrish]

Thanks @Alberto_Umana