1. SQL Language Reference
  2. Functions
  3. ORA_INVOKING_USERID

ORA_INVOKING_USERID

Syntax

Description of ora_invoking_userid.eps follows
Description of the illustration ora_invoking_userid.eps

Purpose

ORA_INVOKING_USERID returns the identifier of the database user who invoked the current statement or view. This function takes into account the BEQUEATH property of intervening views referenced in the statement.

This function returns a NUMBER value.

See Also:

  • ORA_INVOKING_USER to learn how Oracle Database determines the database user who invoked the current statement or view

  • BEQUEATH clause of the CREATE VIEW statement

Examples

The following example returns the identifier of the database user who invoked the statement:

SELECT ORA_INVOKING_USERID FROM DUAL;