本文介绍RDS PostgreSQL高权限账号访问系统表和视图的权限。
类别 | 名称 | PostgreSQL 13 | PostgreSQL 12 | PostgreSQL 11 | PostgreSQL 10 | PostgreSQL 9.4 |
---|---|---|---|---|---|---|
系统表 | pg_aggregate | √ | √ | √ | √ | √ |
pg_am | √ | √ | √ | √ | √ | |
pg_amop | √ | √ | √ | √ | √ | |
pg_amproc | √ | √ | √ | √ | √ | |
pg_attrdef | √ | √ | √ | √ | √ | |
pg_attribute | √ | √ | √ | √ | √ | |
pg_authid | × | × | × | × | × | |
pg_auth_members | √ | √ | √ | √ | √ | |
pg_cast | √ | √ | √ | √ | √ | |
pg_class | √ | √ | √ | √ | √ | |
pg_collation | √ | √ | √ | √ | √ | |
pg_constraint | √ | √ | √ | √ | √ | |
pg_conversion | √ | √ | √ | √ | √ | |
pg_database | √ | √ | √ | √ | √ | |
pg_db_role_setting | √ | √ | √ | √ | √ | |
pg_default_acl | √ | √ | √ | √ | √ | |
pg_depend | √ | √ | √ | √ | √ | |
pg_description | √ | √ | √ | √ | √ | |
pg_enum | √ | √ | √ | √ | √ | |
pg_event_trigger | √ | √ | √ | √ | √ | |
pg_extension | √ | √ | √ | √ | √ | |
pg_foreign_data_wrapper | √ | √ | √ | √ | √ | |
pg_foreign_server | √ | √ | √ | √ | √ | |
pg_foreign_table | √ | √ | √ | √ | √ | |
pg_index | √ | √ | √ | √ | √ | |
pg_inherits | √ | √ | √ | √ | √ | |
pg_init_privs | √ | √ | √ | √ | 不涉及 | |
pg_language | √ | √ | √ | √ | √ | |
pg_largeobject | × | × | × | × | × | |
pg_largeobject_metadata | √ | √ | √ | √ | √ | |
pg_namespace | √ | √ | √ | √ | √ | |
pg_opclass | √ | √ | √ | √ | √ | |
pg_operator | √ | √ | √ | √ | √ | |
pg_opfamily | √ | √ | √ | √ | √ | |
pg_partitioned_table | √ | √ | √ | √ | 不涉及 | |
pg_pltemplate | √ | √ | √ | √ | √ | |
pg_policy | √ | √ | √ | √ | 不涉及 | |
pg_proc | √ | √ | √ | √ | √ | |
pg_publication | √ | √ | √ | √ | 不涉及 | |
pg_publication_rel | √ | √ | √ | √ | 不涉及 | |
pg_range | √ | √ | √ | √ | √ | |
pg_replication_origin | √ | √ | √ | √ | 不涉及 | |
pg_rewrite | √ | √ | √ | √ | √ | |
pg_replication_slots | 不涉及 | 不涉及 | 不涉及 | 不涉及 | √ | |
pg_seclabel | √ | √ | √ | √ | √ | |
pg_sequence | √ | √ | √ | √ | 不涉及 | |
pg_shdepend | √ | √ | √ | √ | √ | |
pg_shdescription | √ | √ | √ | √ | √ | |
pg_shseclabel | √ | √ | √ | √ | √ | |
pg_statistic | × | × | × | × | × | |
pg_statistic_ext | √ | √ | √ | √ | 不涉及 | |
pg_statistic_ext_data | × | × | 不涉及 | 不涉及 | 不涉及 | |
pg_subscription | √ | √ | √ | √ | 不涉及 | |
pg_subscription_rel | √ | √ | √ | √ | 不涉及 | |
pg_tablespace | √ | √ | √ | √ | √ | |
pg_transform | √ | √ | √ | √ | 不涉及 | |
pg_trigger | √ | √ | √ | √ | √ | |
pg_ts_config | √ | √ | √ | √ | √ | |
pg_ts_config_map | √ | √ | √ | √ | √ | |
pg_ts_dict | √ | √ | √ | √ | √ | |
pg_ts_parser | √ | √ | √ | √ | √ | |
pg_ts_template | √ | √ | √ | √ | √ | |
pg_type | √ | √ | √ | √ | √ | |
pg_user_mapping | × | × | × | × | × | |
系统视图 | pg_available_extensions | √ | √ | √ | √ | √ |
pg_available_extension_versions | √ | √ | √ | √ | √ | |
pg_config | × | × | × | × | 不涉及 | |
pg_cursors | √ | √ | √ | √ | √ | |
pg_file_settings | × | × | × | × | 不涉及 | |
pg_group | √ | √ | √ | √ | √ | |
pg_hba_file_rules | × | × | × | × | 不涉及 | |
pg_indexes | √ | √ | √ | √ | √ | |
pg_locks | √ | √ | √ | √ | √ | |
pg_matviews | √ | √ | √ | √ | √ | |
pg_policies | √ | √ | √ | √ | 不涉及 | |
pg_prepared_statements | √ | √ | √ | √ | √ | |
pg_prepared_xacts | √ | √ | √ | √ | √ | |
pg_publication_tables | √ | √ | √ | √ | 不涉及 | |
pg_replication_origin_status | √ | √ | √ | × | 不涉及 | |
pg_replication_slots | √ | √ | √ | √ | 不涉及 | |
pg_roles | √ | √ | √ | √ | √ | |
pg_rules | √ | √ | √ | √ | √ | |
pg_seclabels | √ | √ | √ | √ | √ | |
pg_sequences | √ | √ | √ | √ | 不涉及 | |
pg_settings | √ | √ | √ | √ | √ | |
pg_shadow | × | × | × | × | × | |
pg_stats | √ | √ | √ | √ | √ | |
pg_stats_ext | √ | √ | 不涉及 | 不涉及 | 不涉及 | |
pg_tables | √ | √ | √ | √ | √ | |
pg_timezone_abbrevs | √ | √ | √ | √ | √ | |
pg_timezone_names | √ | √ | √ | √ | √ | |
pg_user | √ | √ | √ | √ | √ | |
pg_user_mappings | √ | √ | √ | √ | √ | |
pg_views | √ | √ | √ | √ | √ |