Inherited privileges

You can manage inheritance of privileges at three levels:.

You can manage inheritance of privileges at three levels:

Database
Schema
Tables, views, and models

By default, inherited privileges are enabled at the database level and disabled at the schema level. If privilege inheritance is enabled at both levels, newly created tables, views, and models automatically inherit their parent schema's privileges. You can also disable privilege inheritance on individual objects with the following statements:

CREATE TABLE/ALTER TABLE
CREATE VIEW/ALTER VIEW
ALTER MODEL

In this section

Enabling database inheritance
Enabling schema inheritance
Setting privilege inheritance on tables and views
Example usage: implementing inherited privileges