Inherited Privileges

You can manage inheritance of privileges at three levels:

  • Database
  • Schema
  • Tables and views

By default, inherited privileges are enabled at the database level and disabled at the schema level. If privilege inheritance is enabled at both levels, new tables and views automatically inherit those privileges when they are created. You can also exclude inheritance from specific tables and views.

In This Section