INHERITING_OBJECTS

Provides information about which tables and views inherit privileges from which schemas.

For information about the specific 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 the object inheriting the privileges.
SCHEMA_ID INTEGER Catalog-assigned integer value that uniquely identifies the parent schema.
OBJECT_SCHEMA VARCHAR Name of the parent schema of a table or view.
OBJECT_NAME VARCHAR Name of the table or view.
OBJECT_TYPE VARCHAR Table or view.

Example

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
 (3 rows)

See Also