INHERITING_OBJECTS

提供哪些表和视图从哪些架构继承权限的相关信息。

有关从架构及其关联的 GRANT 语句继承的特定权限的信息，请参阅 INHERITED_PRIVILEGES 表。

示例

以下查询返回从父架构（即客户）继承其权限的表和视图。

=> 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)

另请参阅