Fetch Functions - Read-Only User

Fetch Functions - Read-Only User

  1. SELECT string_agg(format('%I(%s)', p.proname, pg_catalog.pg_get_function_identity_arguments(p.oid)),',') AS functions FROM pg_catalog.pg_proc p JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace WHERE p.proname in('version','current_catalog','current_database','current_query','current_role','current_schema','current_user','inet_client_addr','inet_client_port','inet_server_addr','inet_server_port','pg_backend_pid','pg_conf_load_time','pg_is_other_temp_schema','pg_listening_channels','pg_my_temp_schema','pg_postmaster_start_time','pg_trigger_depth','session_user','user','has_any_column_privilege','has_column_privilege','has_database_privilege','has_foreign_data_wrapper_privilege','has_function_privilege','has_language_privilege','has_schema_privilege','has_sequence_privilege','has_server_privilege','has_table_privilege','has_tablespace_privilege','has_type_privilege','pg_has_role','pg_collation_is_visible','pg_conversion_is_visible','pg_function_is_visible','pg_opclass_is_visible','pg_operator_is_visible','pg_opfamily_is_visible','pg_table_is_visible','pg_ts_config_is_visible','pg_ts_dict_is_visible','pg_ts_parser_is_visible','pg_ts_template_is_visible','pg_type_is_visible','format_type','pg_describe_object','pg_get_constraintdef','pg_get_functiondef','pg_get_function_arguments','pg_get_function_identity_arguments','pg_get_function_result','pg_get_indexdef','pg_get_keywords','pg_get_ruledef','pg_get_serial_sequence','pg_get_triggerdef','pg_get_userbyid','pg_get_viewdef','pg_options_to_table','pg_tablespace_databases','pg_tablespace_location','pg_typeof','pg_collation_for','col_description','obj_description','shobj_description','txid_current','txid_current_snapshot','txid_snapshot_xip','txid_snapshot_xmax','txid_snapshot_xmin','txid_visible_in_snapshot','current_setting','set_config','pg_cancel_backend','pg_reload_conf','pg_rotate_logfile','pg_terminate_backend','pg_create_restore_point','pg_current_xlog_insert_location','pg_current_xlog_location','pg_start_backup','pg_stop_backup','pg_switch_xlog','pg_xlogfile_name','pg_xlogfile_name_offset','pg_xlog_location_diff','pg_is_in_recovery','pg_last_xlog_receive_location','pg_last_xlog_replay_location','pg_last_xact_replay_timestamp','pg_is_xlog_replay_paused','pg_xlog_replay_pause','pg_xlog_replay_resume','pg_column_size','pg_database_size','pg_indexes_size','pg_relation_size','pg_size_pretty','pg_table_size','pg_tablespace_size','pg_total_relation_size','pg_ls_dir','pg_read_file','pg_read_binary_file','pg_stat_file','pg_advisory_lock','pg_advisory_lock_shared','pg_advisory_unlock_all','pg_advisory_unlock_shared','pg_advisory_xact_lock','pg_advisory_xact_lock_shared','pg_try_advisory_lock','pg_try_advisory_lock_shared','pg_try_advisory_xact_lock','pg_try_advisory_xact_lock_shared','pg_settings','pg_stat_activity','pg_sleep','CERTENCODED','CERTPRIVATEKEY','CURRENT_USER','DATABASE_PRINCIPAL_ID','HAS_DBACCESS','HAS_PERMS_BY_NAME','IS_MEMBER','IS_ROLEMEMBER','IS_SRVROLEMEMBER','LOGINPROPERTY','ORIGINAL_LOGIN','PERMISSIONS','PWDENCRYPT','PWDCOMPARE','SESSION_USER','SESSIONPROPERTY','SUSER_ID','USER_NAME','SUSER_SID','SUSER_SNAME','SYSTEM_USER','USER','USER_ID','pg_advisory_unlock','GENERATE_SERIES','pg_sleep_for','pg_sleep_until','pg_blocking_pids','pg_current_logfile','pg_notification_queue_usage','pg_safe_snapshot_blocking_pids','row_security_active','pg_statistics_obj_is_visible','pg_get_statisticsobjdef','pg_index_column_has_property','pg_index_has_property','pg_indexam_has_property','to_regclass','to_regproc','to_regprocedure','to_regoper','to_regoperator','to_regtype','to_regnamespace','to_regrole','pg_identify_object','pg_identify_object_as_address','txid_current_if_assigned','txid_status','pg_xact_commit_timestamp','pg_last_committed_xact','pg_control_checkpoint','pg_control_system','pg_control_init','pg_control_recovery','pg_current_wal_flush_lsn','pg_current_wal_insert_lsn','pg_current_wal_lsn','pg_is_in_backup','pg_backup_start_time','pg_switch_wal','pg_walfile_name','pg_walfile_name_offset','pg_wal_lsn_diff','pg_last_wal_receive_lsn','pg_last_wal_replay_lsn','pg_is_wal_replay_paused','pg_wal_replay_pause','pg_wal_replay_resume','pg_create_physical_replication_slot','pg_drop_replication_slot','pg_create_logical_replication_slot','pg_logical_slot_get_changes','pg_logical_slot_peek_changes','pg_logical_slot_get_binary_changes','pg_logical_slot_peek_binary_changes','pg_replication_origin_create','pg_replication_origin_drop','pg_replication_origin_oid','pg_replication_origin_session_setup','pg_replication_origin_session_reset','pg_replication_origin_session_is_setup','pg_replication_origin_session_progress','pg_replication_origin_xact_setup','pg_replication_origin_xact_reset','pg_replication_origin_advance','pg_replication_origin_progress','pg_logical_emit_message','pg_size_bytes','pg_filenode_relation','pg_collation_actual_version','pg_import_system_collations','brin_summarize_new_values','brin_summarize_range','brin_desummarize_range','gin_clean_pending_list','pg_ls_logdir','pg_ls_waldir','pg_stat_replication','pg_export_snapshot','pg_relation_filenode','pg_relation_filepath','pg_get_owned_sequence','pg_get_object_address','pg_read_all_stats','collationfor','collationfor','current_catalog','current_role','current_schema','current_user ','session_user','user');

    • Related Articles

    • Global Functions

      Custom functions allow users to manipulate data in AssetExplorer and other external applications. Custom functions are built on Deluge, Zoho's propriety scripting language. Global functions are custom functions that can be called from custom actions ...

    • Configure User Additional Fields

      Based on your requirements, the default user record can be customized using different types of additional fields. This is useful to capture user-related additional information. Role Required: SDAdmin Go to Admin > Organizational Details > Roles. ...

    • Importing User-Defined Fields

      Role Required: SDAdmin You can import default user attributes such as the login name, distinguished name, and domain name fields. Other user attributes such as phone, mobile, department, office, jobTitle, and email are mapped to LDAP attributes in ...

    • View, Edit, or Delete User Additional Fields

      You can view all user additional fields and perform various actions under Admin > Organizational Details > Roles. Role Required: SDAdmin To edit a field, click the icon. Make necessary changes and click Save. To delete a field, click the icon against ...

    • Query Reports

      Query Reports are reports that can be generated using an SQL query. Role Required: SDAdmin; Technicians who have Complete Access to reports and Create Query Report permission. To create a new query report, Go to the Reports tab and click New Query ...