This topic describes the permissions that the privileged account of an ApsaraDB RDS for PostgreSQL instance has on system tables and views.

Note In this table, the check sign (√) indicates that the privileged account has permissions on the specified system table or view. The cross sign (×) indicates that the privileged account does not have permissions on the specified system table or view.
Type Name PostgreSQL 13 PostgreSQL 12 PostgreSQL 11 PostgreSQL 10 PostgreSQL 9.4
System table 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 √ √ √ √ N/A
pg_language √ √ √ √ √
pg_largeobject × × × × ×
pg_largeobject_metadata √ √ √ √ √
pg_namespace √ √ √ √ √
pg_opclass √ √ √ √ √
pg_operator √ √ √ √ √
pg_opfamily √ √ √ √ √
pg_partitioned_table √ √ √ √ N/A
pg_pltemplate √ √ √ √ √
pg_policy √ √ √ √ N/A
pg_proc √ √ √ √ √
pg_publication √ √ √ √ N/A
pg_publication_rel √ √ √ √ N/A
pg_range √ √ √ √ √
pg_replication_origin √ √ √ √ N/A
pg_rewrite √ √ √ √ √
pg_replication_slots N/A N/A N/A N/A √
pg_seclabel √ √ √ √ √
pg_sequence √ √ √ √ N/A
pg_shdepend √ √ √ √ √
pg_shdescription √ √ √ √ √
pg_shseclabel √ √ √ √ √
pg_statistic × × × × ×
pg_statistic_ext √ √ √ √ N/A
pg_statistic_ext_data × × N/A N/A N/A
pg_subscription √ √ √ √ N/A
pg_subscription_rel √ √ √ √ N/A
pg_tablespace √ √ √ √ √
pg_transform √ √ √ √ N/A
pg_trigger √ √ √ √ √
pg_ts_config √ √ √ √ √
pg_ts_config_map √ √ √ √ √
pg_ts_dict √ √ √ √ √
pg_ts_parser √ √ √ √ √
pg_ts_template √ √ √ √ √
pg_type √ √ √ √ √
pg_user_mapping × × × × ×
System view pg_available_extensions √ √ √ √ √
pg_available_extension_versions √ √ √ √ √
pg_config × × × × N/A
pg_cursors √ √ √ √ √
pg_file_settings × × × × N/A
pg_group √ √ √ √ √
pg_hba_file_rules × × × × N/A
pg_indexes √ √ √ √ √
pg_locks √ √ √ √ √
pg_matviews √ √ √ √ √
pg_policies √ √ √ √ N/A
pg_prepared_statements √ √ √ √ √
pg_prepared_xacts √ √ √ √ √
pg_publication_tables √ √ √ √ N/A
pg_replication_origin_status √ √ √ × N/A
pg_replication_slots √ √ √ √ N/A
pg_roles √ √ √ √ √
pg_rules √ √ √ √ √
pg_seclabels √ √ √ √ √
pg_sequences √ √ √ √ N/A
pg_settings √ √ √ √ √
pg_shadow × × × × ×
pg_stats √ √ √ √ √
pg_stats_ext √ √ N/A N/A N/A
pg_tables √ √ √ √ √
pg_timezone_abbrevs √ √ √ √ √
pg_timezone_names √ √ √ √ √
pg_user √ √ √ √ √
pg_user_mappings √ √ √ √ √
pg_views √ √ √ √ √