Pre-16.0 Privileged System Procedures

A list of pre-16.0 privileged system procedures.

Pre-16.0 privileged system procedures that use the combined security model

For these privileged system procedures, if the database is configured to run using SYSTEM PROCEDURE DEFINER, you only need EXECUTE privilege on the procedure to run it. If the database is configured to run using SYSTEM PROCEDURE INVOKER, you need the individual privileges that each procedure requires to run successfully. Refer to the documentation for each procedure's required system privileges.

  • sa_audit_string
  • sa_checkpoint_execute
  • sa_clean_database
  • sa_column_stats
  • sa_conn_activity
  • sa_conn_compression_info
  • sa_conn_info
  • sa_conn_list
  • sa_conn_options
  • sa_conn_properties
  • sa_db_info
  • sa_db_list
  • sa_db_properties
  • sa_disable_auditing_type
  • sa_disk_free_space
  • sa_enable_auditing_type
  • sa_external_library_unload
  • sa_flush_cache
  • sa_flush_statistics
  • sa_get_histogram
  • sa_get_request_profile
  • sa_get_request_times
  • sa_get_table_definition
  • sa_get_user_status
  • sa_index_density
  • sa_index_levels
  • sa_install_feature
  • sa_java_loaded_classes
  • sa_list_external_library
  • sa_load_cost_model
  • sa_materialized_view_can_be_immediate
  • sa_procedure_profile
  • sa_procedure_profile_summary
  • sa_recompile_views
  • sa_refresh_materialized_views
  • sa_refresh_text_indexes
  • sa_remove_index_consultant_analysis
  • sa_reset_identity
  • sa_save_trace_data
  • sa_send_udp
  • sa_server_option
  • sa_table_fragmentation
  • sa_table_page_usage
  • sa_table_stats
  • sa_text_index_stats
  • sa_text_index_vocab
  • sa_text_index_vocab_nchar
  • sa_unload_cost_model
  • sa_user_defined_counter_add
  • sa_user_defined_counter_set
  • sa_validate
  • sp_iq_reset_identity
  • sp_iqaddlogin
  • sp_iqbackupdetails
  • sp_iqbackupsummary
  • sp_iqcardinality_analysis
  • sp_iqcheckdb
  • sp_iqcheckoptions
  • sp_iqclient_lookup
  • sp_iqcolumn
  • sp_iqcolumnuse
  • sp_iqconnection
  • sp_iqconstraint
  • sp_iqcontext
  • sp_iqcopyloginpolicy
  • sp_iqcursorinfo
  • sp_iqdatatype
  • sp_iqdbsize
  • sp_iqdbspace
  • sp_iqdbspaceinfo
  • sp_iqdbspaceobjectinfo
  • sp_iqdbstatistics
  • sp_iqdroplogin
  • sp_iqemptyfile
  • sp_iqestdbspaces
  • sp_iqestspace
  • sp_iqevent
  • sp_iqfile
  • sp_iqhelp
  • sp_iqindex
  • sp_iqindex_alt
  • sp_iqindexadvice
  • sp_iqindexfragmentation
  • sp_iqindexinfo
  • sp_iqindexmetadata
  • sp_iqindexsize
  • sp_iqindexuse
  • sp_iqlmconfig
  • sp_iqlocks
  • sp_iqmodifyadmin
  • sp_iqmodifylogin
  • sp_iqmpxcheckdqpconfig
  • sp_iqmpxdumptlvlog
  • sp_iqmpxfilestatus
  • sp_iqmpxincconnpoolinfo
  • sp_iqmpxincheartbeatinfo
  • sp_iqmpxinfo
  • sp_iqmpxversioninfo
  • sp_iqobjectinfo
  • sp_iqpkeys
  • sp_iqprocedure
  • sp_iqprocparm
  • sp_iqrebuildindex
  • sp_iqrename
  • sp_iqrestoreaction
  • sp_iqrowdensity
  • sp_iqsetcompression
  • sp_iqsharedtempdistrib
  • sp_iqshowcompression
  • sp_iqshowpsexe
  • sp_iqspaceinfo
  • sp_iqspaceused
  • sp_iqstatistics
  • sp_iqstatus
  • sp_iqsysmon
  • sp_iqtable
  • sp_iqtablesize
  • sp_iqtableuse
  • sp_iqtransaction
  • sp_iqunusedcolumn
  • sp_iqunusedindex
  • sp_iqunusedtable
  • sp_iqversionuse
  • sp_iqview
  • sp_iqwho
  • sp_iqworkmon
  • st_geometry_load_shapefile
  • xp_cmdshell
  • xp_read_file
  • xp_sendmail
  • xp_startmail
  • xp_startsmtp
  • xp_stopmail
  • xp_stopsmtp
  • xp_write_file

Pre-16.0 privileged system procedures that run with invoker privileges regardless of the security model

These pre-16.0 privileged system procedures run with the privileges of the user running the procedure, not the owner of the procedure, regardless of the security model setting. This means that in addition to requiring EXECUTE privilege on the system procedure, the user must be granted additional system privileges required by the system procedure. Refer to the documentation for the required system privileges.
  • sa_describe_shapefile
  • sa_get_user_status
  • sa_locks
  • sa_performance_diagnostics
  • sa_report_deadlocks
  • sa_text_index_stats