Using an application context

In this recipe, you'll see one possible usage (in SQL) of the application contexts. Some other usages are shown in other parts of the book, and their references are given in the See also section of this recipe.

Getting ready

Create a new user (for example, sofia). Make sure that his or her e-mail in the format [e-mail] is unique. Grant him or her privileges: create session and select on sh.customers table.

Figure 12 - New user

Insert data about him or her into the sh.customers table.

Figure 13 - The new data in sh.customers

How to do it...

1. Connect to the database as a newly created user (for example, user sofia):

   $ sqlplus sofia
   

2. Verify that the user (for example, sofia) can access all data in the sh.customers table.
   

   Figure 14 - The entire data in sh.customers

3. Verify that when executing the following statement, he or she (for example, sofia) can view only his or her data.
   

   Figure 15 - Only data about newly created user

How it works...

In step 3, a...