Pre-16.0 Privileged System Procedures

A list of pre-16.0 privileged system procedures.

Privileged System Procedures Using the Combined Security Model

For these privileged system procedures, if the database is configured to use SYSTEM PROCEDURE DEFINER, you only need EXECUTE object-level privilege on the procedure to run it. If the database is configured to use SYSTEM PROCEDURE INVOKER, you also need the individual system privileges required by each procedure. Refer to the Reference: Building Blocks, Tables, and Procedures Guide for the system privileges require to run each system procedure.

sa_audit_string
sa_checkpoint_execute
sa_disable_auditing_type
sa_disk_free_space
sa_enable_auditing_type
sa_external_library_unload
sa_flush_cache
sa_list_external_library
sa_server_option
sa_procedure_profile
sa_procedure_profile_summary
sa_table_page_usage
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_iqconstraint
sp_iqcontext
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_iqcopyloginpolicy
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

Privileged System Procedures Using Invoker Privileges

These pre-16.0 privileged system procedures run with the privileges of the user who is running the procedure, not the owner of the procedure, regardless of the security model setting. Therefore, in addition to the EXECUTE object-level privilege on the system procedure, (which is, by default, granted through membership in PUBLIC role), you must also be granted the additional system privileges required by the system procedure. Refer to the Reference: Building Blocks, Tables, and Procedures Guide for the system privileges required to run each system procedure.

sa_describe_shapefile
sa_get_user_status
sa_locks
sa_performance_diagnostics
sa_report_deadlocks
sa_text_index_stats