Example 4: Users Require Differing Access to Application and Databases

Three employees need to use Essbase—Sue Smith, Bill Brown, and Jane Jones. Sue requires full access only to the Sample application; Jane requires calculate access to all members of the Basic database; Bill requires read access to all members. No other users should have access to the databases.

Furthermore, Jane and Bill need to run report scripts that are defined by Sue.

Solution When Using Essbase in Native Security Mode:

Because the different users have different needs for application and database access, define the global access setting as None, and assign the user permissions individually.

The Administrator should perform the following tasks:

  1. Set up the users with Administration Services. (Because Jane and Bill need to run the report scripts, they must use Administration Services.)

    See the Oracle Essbase Administration Services Online Help.

  2. Create Sue as an ordinary user, and grant her Application Manager permission for the Sample application.

    See Creating Users in Essbase Native Security Mode and Granting Designer Permissions to Users and Groups in Essbase Native Security Mode.

  3. Create Jane as an ordinary user, and give her Calculate permission for the Sample application.

    See Creating Users in Essbase Native Security Mode and Granting Application and Database Access to Users and Groups in Essbase Native Security Mode.

  4. Create Bill as an ordinary user and give him read permission on the Sample application.

    See Creating Users in Essbase Native Security Mode and Granting Application and Database Access to Users and Groups in Essbase Native Security Mode.