Exploring and using built-in contexts
The USERENV application context is a built-in context that contains information about the current session. In this recipe, you'll learn to retrieve values from built-in contexts.
Getting ready
To complete this recipe, you'll need an existing user who can get values from built-in namespaces by using the SYS_CONTEXT function (for example, user maja).
How to do it...
- Connect to the database as a user who has appropriate privileges (for example, user
maja):$ sqlplus maja - Find the name of host machine from which the client has connected to the database.
Figure 2 - The name of the client host machine
- Find the name of the user who logged on to the database.
Figure 3 - The name of the session user
- Find the name of the program used for the database session.
Figure 4 - The name of the client program
- Find unified audit session ID.
Figure 5 - A unified audit session ID
How it works...
In steps 2-5, you used the SYS_CONTEXT function to get values of several parameters...
