The syntax for the userenv function is:
userenv( parameter )
parameter is the value to return from the current Oracle session.
For Example:
userenv('ENTRYID') | would return FALSE |
userenv('LANGUAGE') | would return 'AMERICAN_AMERICA.WE8DEC' |
The possible values for parameter are:
Parameter | Explanation |
---|---|
CLIENT_INFO | Returns user session information stored using the DBMS_APPLICATION_INFO package |
ENTRYID | Available auditing entry identifier |
INSTANCE | The identifier number of the current instance |
ISDBA | Returns TRUE if the user has DBA privileges. Otherwise, it will return FALSE. |
LANG | The ISO abbreviation for the language |
LANGUAGE | The language, territory, and character of the session. In the following format: language_territory.characterset |
SESSIONID | The identifier of the auditing session |
TERMINAL | The OS identifier of the current session |
No comments:
Post a Comment