INHERITING_OBJECTS

Provides information about the objects (table, view, or model) that inherit privileges from their parent schemas.

Provides information about the objects (table, view, or model) that inherit privileges from their parent schemas.

For information about the particular privileges inherited from schemas and their associated GRANT statements, see the INHERITED_PRIVILEGES table.

Column Name Data Type Description
OBJECT_ID INTEGER Catalog-assigned integer value that uniquely identifies theobject inheriting the privileges.
SCHEMA_ID INTEGER Catalog-assigned integer value that uniquely identifies theparent schema.
OBJECT_SCHEMA VARCHAR Name of the parent schema.
OBJECT_NAME VARCHAR Name of the object.
OBJECT_TYPE VARCHAR

The object type, one of the following:

  • Table

  • View

  • Model

Examples

The following query returns the tables and views that inherit their privileges from their parent schema, customers.

=> SELECT * FROM inheriting_objects WHERE object_schema='customers';
     object_id     |     schema_id     | object_schema |  object_name      | object_type
 ------------------+-------------------+---------------+-------------------+-------------
 45035996273980908 | 45035996273980902 | customers     | cust_info         | table
 45035996273980984 | 45035996273980902 | customers     | shipping_info     | table
 45035996273980980 | 45035996273980902 | customers     | cust_set          | view
 45035996273980983 | 45035996273980901 | ml_models     | clustering_model  | model
 (3 rows)

See also