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 ...
    • Microsoft Entra ID (Azure AD) User Sync

      Asset Explorer enables you to import users from Microsoft Entra ID (Azure AD) based on certain criteria. You can map Azure AD user fields with Asset Explorer fields to import specific user details. You can also automatically sync deleted users from ...
    • 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 ...
    • User Asset Booking

      User Asset Booking End users can book assets using the Book Assets option on the self-service portal page. To book an asset, Click Book Assets on the self-service portal. The asset booking form opens up. Select an asset type and enter the booking ...