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