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 user@company.example.com 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 ...
Get Oracle Database 12c Security Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
