Skip Headers
Oracle® Database SQL Language Reference
12c Release 1 (12.1)

E17209-15
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ORA_INVOKING_USER

Syntax

Description of ora_invoking_user.gif follows
Description of the illustration ora_invoking_user.gif

Purpose

ORA_INVOKING_USER returns the name 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. If this function is invoked from within a definer's rights context, then it returns the name of the owner of the definer's rights object. If the invoking user is a Real Application Security user, then it returns user XS$NULL.

This function returns a VARCHAR2 value.

See Also:

Examples

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

SELECT ORA_INVOKING_USER FROM DUAL;