Oracle Database Real Application Security SQL Functions

This chapter describes the SQL functions and procedures that are available with Oracle Database Real Application Security.

Oracle Database Real Application Security SQL Functions and Procedures summarizes these functions and procedures. Detailed information on each function and procedure follows this table.

Oracle Database Real Application Security SQL Functions and Procedures

SQL Function or Procedure Brief Description
COLUMN_AUTH_INDICATOR Function Checks whether the specified table column is authorized on a particular table row.
XS_SYS_CONTEXT Function Retrieves the session attributes and the XS$GLOBAL_VAR namespace attribute for the current application session.
ORA_CHECK_ACL Function Checks whether an application user has the queried application privileges according to a list of ACLs.
ORA_GET_ACLIDS Function Returns a list of ACL identifiers associated with an object instance of the XDS-enabled tables for the current application user.
ORA_CHECK_PRIVILEGE Function Checks whether the specified system privileges have been granted to an application user
TO_ACLID Function Returns the ACL IDs of the supplied ACL names