Establishing Context

An application context is a set of name-value pairs that Oracle Database stores in memory.

An application context is a set of name-value pairs that Oracle Database stores in memory. The application context has a label called a namespace. Inside the context are the name-value pairs (an associative array). An application can use the application context to access session information about a user, such as the user ID or other user-specific information, and then securely pass this data to the database. You can then use this information to either permit or prevent the user from accessing data through the application.

For Oracle Life Sciences Data Hub, you need a name-value pair for each of the following:

• User ID
• User password
• PrrefID of the Program or Business Area

You can set the context as follows:

• If no login is required when the user launches the external system, set the sys_context by writing a function.

• Establish the context with the database logon trigger. The adapter doesn't need to do anything specifically for allowing the user access to the correct data. The Oracle LSH logon trigger uses the user's database account to determine the user's privileges and enables the sources and targets so that the user can view LSH data from the IDE.

  Note:

  For information on application context functionality, logon triggers, and more, see the Oracle® Database Security Guide 11g Release 2 (11.2) at https://docs.oracle.com/cd/E11882_01/server.112/e10575/toc.htm.
• If you are using the Generic Visualization adapter, see Initializing the Business Area Instance.