INHERITING_OBJECTS
Provides information about which tables and views inherit privileges from which schemas.
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 theobject inheriting the privileges. |
| SCHEMA_ID | INTEGER | Catalog-assigned integer value that uniquely identifies theparent 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. |
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
(3 rows)