5 Setting Context in Multi-tenant Environment

In a multi-tenant setup, if you want to view the data related to an enterprise, you must set the context for the enterprise.

To set the context for an enterprise, execute the following steps:

1. Log on to the SQL Developer as the Argus Mart User (AM_MART_USER).

2. Execute the following command:

   pkg_rls.set_context(:LoginUserName, :Enterpriseid, :ARGUS_MART, NULL);

   Where LoginUserName refers to the User Name, Enterpriseid refers to the ID for the enterprise, and ARGUS_MART refers to the Application Name.

   Example: execute pkg_rls.set_context('admin',3,'ARGUS_MART',NULL)

   This completes the steps to set the context for the enterprise.