G Oracle Database Vault DVSYS.DBMS_MACUTL Package

G.2.1 CHECK_DVSYS_DML_ALLOWED Function

This function verifies that public packages are not being bypassed by users updating the Oracle Database Vault configuration.

Syntax

CHECK_DVSYS_DML_ALLOWED(
  p_user VARCHAR2 DEFAULT USER); 

Parameter

G.2.2 GET_CODE_ID Function

This function looks up the ID for a code within a code group, and then returns a NUMBER value. These codes are used for the user interface, views, and for validating input in a translatable fashion.

Syntax

GET_CODE_ID(
  p_code_group VARCHAR2,
  p_code       VARCHAR2); 

Parameters

G.2.3 GET_CODE_VALUE Function

This function looks up the value for a code within a code group, and then returns a VARCHAR2 value.

Syntax

GET_CODE_VALUE(
  p_code_group VARCHAR2, 
  p_code       VARCHAR2); 

Parameters

G.2.4 GET_FACTOR_CONTEXT Function

This function constructs an XML document that contains the values for all of the factors. This XML document is only intended for auditing or tracing and is truncated if it is longer than 4000 characters. The function returns a VARCHAR2 value.

Use this function to retrieve factors at the current time for a session. It is also useful for auditing purposes.

Syntax

GET_FACTOR_CONTEXT();

Parameters

None.

G.2.5 GET_SECOND Function

This function returns the seconds in Oracle SS (seconds) format (00–59), and then returns a NUMBER value. It is useful for rule expressions based on time data.

Syntax

GET_SECOND(
  p_date DATE DEFAULT SYSDATE);

Parameter

G.2.6 GET_MINUTE Function

This function returns the minute in Oracle MI (minute) format (00–59); returns a NUMBER value. Useful for rule expressions based on time data.

Syntax

GET_MINUTE(
  p_date DATE DEFAULT SYSDATE);

Parameter

G.2.7 GET_HOUR Function

This function returns the hour in Oracle HH24 (hour) format (00–23); returns a NUMBER value. Useful for rule expressions based on time data.

Syntax

GET_HOUR(
  p_date DATE DEFAULT SYSDATE); 

Parameter

G.2.8 GET_DAY Function

This function returns the day in Oracle DD (day) format (01–31); returns a NUMBER value. It is useful for rule expressions based on time data.

Syntax

GET_DAY(
  p_date DATE DEFAULT SYSDATE); 

Parameter

G.2.9 GET_MONTH Function

This function returns the month in Oracle MM (month) format (01–12); returns a NUMBER value. Useful for rule expressions based on time data.

Syntax

GET_MONTH(
  p_date DATE DEFAULT SYSDATE);

Parameter

G.2.10 GET_YEAR Function

This function returns the year in Oracle YYYY (year) format (0001–9999); returns a NUMBER value. Useful for rule expressions based on time data.

Syntax

GET_YEAR(
  p_date DATE DEFAULT SYSDATE);

Parameter

G.2.11 GET_SQL_TEXT Function

This function concatenates the elements of ora_name_list_t into a single VARCHAR2 value, and then returns a VARCHAR2 value.

Syntax

GET_SQL_TEXT(
  p_sql_text ora_name_list_t); 

Parameters

G.2.12 IN_CALL_STACK Function

This function checks for a string in the PL/SQL call stack, and then returns a BOOLEAN value. IN_CALL_STACK returns TRUE if the string is in the call stack.

Syntax

IN_CALL_STACK(
  p_search_term VARCHAR2); 

Parameter

G.2.13 IS_ALPHA Function

This function checks whether the character is alphabetic, and then returns a BOOLEAN value. IS_ALPHA returns TRUE if the character is alphabetic.

Syntax

IS_ALPHA(
  c VARCHAR2); 

Parameter

G.2.14 IS_DIGIT Function

This function checks whether the character is numeric, and then returns a BOOLEAN value. IS_DIGIT returns TRUE if the character is a digit.

Syntax

IS_DIGIT(
  c VARCHAR2);

Parameter

G.2.15 IS_DVSYS_OWNER Function

This function determines whether a user is authorized to manage the Oracle Database Vault configuration, and then returns a BOOLEAN value. IS_DVSYS_OWNER returns TRUE if the user is authorized.

Syntax

IS_DVSYS_OWNER(
  p_user VARCHAR2 DEFAULT USER);

Parameter

G.2.16 IS_OLS_INSTALLED Function

This function returns an indicator as to whether or not Oracle Label Security is installed, and then returns a TRUE or FALSE BOOLEAN value. If Oracle Label Security is installed, IS_OLS_INSTALLED returns TRUE.

Syntax

IS_OLS_INSTALLED()

Parameters

None.

G.2.17 IS_OLS_INSTALLED_VARCHAR Function

This function returns an indicator as to whether or not Oracle Label Security is installed, and then returns a Y or N VARCHAR2 value. If Oracle Label Security is installed, IS_OLS_INSTALLED_VARCHAR returns Y.

Syntax

IS_OLS_INSTALLED_VARCHAR()

Parameters

None.

G.2.18 GET_MESSAGE_LABEL Function

This function looks up an Oracle RDBMS error message, and then returns a VARCHAR2 value.

Syntax

GET_MESSAGE_LABEL(
  p_message_code VARCHAR2); 

Parameters

G.2.19 GET_MESSAGE_LABEL Function

This function looks up an Oracle RDBMS error message, and then returns a NUMBER value.

Syntax

GET_MESSAGE_LABEL(
  p_message_code NUMBER); 

Parameters

G.2.20 RAISE_UNAUTHORIZED_OPERATION Function

This function generates an ORA-20920 (Unauthorized Operation) error for unauthorized users.

Syntax

RAISE_UNAUTHORIZED_OPERATION(
  p_user VARCHAR2 DEFAULT USER); 

Parameter

G.2.21 TO_ORACLE_IDENTIFIER Function

This function turns string into a legal Oracle identifier, and then returns a VARCHAR2 value.

Syntax

TO_ORACLE_IDENTIFIER(
  id VARCHAR2);

Parameter

G.2.22 USER_HAS_OBJECT_PRIVILEGE Function

This function checks whether a user or role may access an object through an object privilege grant, and then returns a BOOLEAN value. If the user or role has object privileges, then USER_HAS_OBJECT_PRIVILEGE returns TRUE.

Syntax

USER_HAS_OBJECT_PRIVILEGE(
  p_user          VARCHAR2, 
  p_object_owner  VARCHAR2, 
  p_object_name   VARCHAR2, 
  p_privilege     VARCHAR2); 

Parameters

G.2.23 USER_HAS_ROLE Function

This function checks whether a user has a role privilege, directly or indirectly (through another role), and then returns a BOOLEAN value. If the user has a role privilege, then USER_HAS_ROLE returns TRUE.

Syntax

USER_HAS_ROLE(
  p_role VARCHAR2, 
  p_user VARCHAR2 DEFAULT USER);

Parameters

G.2.24 USER_HAS_ROLE_VARCHAR Function

This function checks whether a user has a role privilege, directly or indirectly (through another role), and then returns a VARCHAR2 value. If the user has the role privilege specified, then USER_HAS_ROLE_VARCHAR returns Y.

Syntax

USER_HAS_ROLE_VARCHAR(
  p_role VARCHAR2, 
  p_user VARCHAR2 DEFAULT USER);

Parameters

G.2.25 USER_HAS_SYSTEM_PRIVILEGE Function

This function checks whether a user has a system privilege, directly or indirectly (through a role), and then returns a BOOLEAN value. If the user has the system privilege specified, then USER_HAS_SYSTEM_PRIVILEGE returns TRUE.

Syntax

USER_HAS_SYSTEM_PRIVILEGE(
  p_privilege  VARCHAR2, 
  p_user       VARCHAR2 DEFAULT USER);

Parameters