ACTION |
Identifies the position in the module (application name) and is set through the DBMS_APPLICATION_INFO package or OCI. |
32 |
AUDITED_CURSORID |
Returns the cursor ID of the SQL that triggered the audit. This parameter is not valid in a fine-grained auditing environment. If you specify it in such an environment, Oracle Database always returns NULL . |
NA |
AUTHENTICATION_DATA |
Data being used to authenticate the login user. For X.503 certificate authenticated sessions, this field returns the context of the certificate in HEX2 format.
Note: You can change the return value of the AUTHENTICATION_DATA attribute using the length parameter of the syntax. Values of up to 4000 are accepted. This is the only attribute of USERENV for which Oracle Database implements such a change. |
256 |
AUTHENTICATION_TYPE |
How the user was authenticated:
-
DATABASE : user name/password authentication
-
OS : operating system external user authentication
-
NETWORK : network protocol or ANO authentication
-
PROXY : OCI proxy connection authentication
|
30 |
BG_JOB_ID |
Job ID of the current session if it was established by an Oracle Database background process. Null if the session was not established by a background process. |
64 |
CLIENT_IDENTIFIER |
Returns an identifier that is set by the application through the DBMS_SESSION.SET_IDENTIFIER procedure, the OCI attribute OCI_ATTR_CLIENT_IDENTIFIER , or the Java class Oracle.jdbc.OracleConnection.setClientIdentifier . This attribute is used by various database components to identify lightweight application users who authenticate as the same database user. |
64 |
CLIENT_INFO |
Returns up to 64 bytes of user session information that can be stored by an application using the DBMS_APPLICATION_INFO package. |
64 |
CURRENT_SCHEMA |
Name of the default schema being used in the current schema. This value can be changed during the session with an ALTER SESSION SET CURRENT_SCHEMA statement. |
30 |
CURRENT_SCHEMAID |
Identifier of the default schema being used in the current session. |
30 |
CURRENT_SQL
CURRENT_SQL n
|
CURRENT_SQL returns the first 4K bytes of the current SQL that triggered the fine-grained auditing event. The CURRENT_SQL n attributes return subsequent 4K-byte increments, where n can be an integer from 1 to 7, inclusive. CURRENT_SQL1 returns bytes 4K to 8K; CURRENT_SQL2 returns bytes 8K to 12K, and so forth. You can specify these attributes only inside the event handler for the fine-grained auditing feature. |
4 |
CURRENT_USER |
This attribute is being deprecated. Use the SESSION_USER attribute instead. |
30 |
CURRENT_USERID |
This attribute is being deprecated. Use the SESSION_USERID attribute instead. |
30 |
DB_DOMAIN |
Domain of the database as specified in the DB_DOMAIN initialization parameter. |
256 |
DB_NAME |
Name of the database as specified in the DB_NAME initialization parameter. |
30 |
DB_UNIQUE_NAME |
Name of the database as specified in the DB_UNIQUE_NAME initialization parameter. |
30 |
ENTRYID |
The current audit entry number. The audit entryid sequence is shared between fine-grained audit records and regular audit records. You cannot use this attribute in distributed SQL statements. |
30 |
EXTERNAL_NAME |
External name of the database user. For SSL authenticated sessions using v.503 certificates, this parameter returns the distinguished name (DN) stored in the user certificate. |
256 |
FG_JOB_ID |
Job ID of the current session if it was established by a client foreground process. Null if the session was not established by a foreground process. |
30 |
GLOBAL_CONTEXT_MEMORY |
Returns the number being used in the System Global Area by the globally accessed context. |
NA |
HOST |
Name of the host machine from which the client has connected. |
54 |
INSTANCE |
The instance identification number of the current instance. |
30 |
IP_ADDRESS |
IP address of the machine from which the client is connected. |
30 |
ISDBA |
Returns TRUE if the user has been authenticated as having DBA privileges either through the operating system or through a password file. |
30 |
LANG |
The ISO abbreviation for the language name, a shorter form than the existing 'LANGUAGE ' parameter. |
62 |
LANGUAGE |
The language and territory currently used by your session, along with the database character set, in this form:
language_territory.characterset |
52 |
MODULE |
The application name (module) set through the DBMS_APPLICATION_INFO package or OCI. |
48 |
NETWORK_PROTOCOL |
Network protocol being used for communication, as specified in the 'PROTOCOL =protocol ' portion of the connect string. |
256 |
NLS_CALENDAR |
The current calendar of the current session. |
62 |
NLS_CURRENCY |
The currency of the current session. |
62 |
NLS_DATE_FORMAT |
The date format for the session. |
62 |
NLS_DATE_LANGUAGE |
The language used for expressing dates. |
62 |
NLS_SORT |
BINARY or the linguistic sort basis. |
62 |
NLS_TERRITORY |
The territory of the current session. |
62 |
OS_USER |
Operating system user name of the client process that initiated the database session. |
30 |
PROXY_USER |
Name of the database user who opened the current session on behalf of SESSION_USER . |
30 |
PROXY_USERID |
Identifier of the database user who opened the current session on behalf of SESSION_USER . |
30 |
SERVICE_NAME |
The name of the service to which a given session is connected. |
64 |
SESSION_USER |
Database user name by which the current user is authenticated. This value remains the same throughout the duration of the session. |
30 |
SESSION_USERID |
Identifier of the database user name by which the current user is authenticated. |
30 |
SESSIONID |
The auditing session identifier. You cannot use this attribute in distributed SQL statements. |
30 |
STATEMENTID |
The auditing statement identifier. STATEMENTID represents the number of SQL statements audited in a given session. |
NA |
TERMINAL |
The operating system identifier for the client of the current session. In distributed SQL statements, this attribute returns the identifier for your local session. In a distributed environment, this is supported only for remote SELECT statements, not for remote INSERT , UPDATE , or DELETE operations. (The return length of this parameter may vary by operating system.) |
10 |