Example 3: Users Require Differing Access to Databases; Users Will Be Added

Three employees need to use Essbase—Sue Smith, Bill Brown, and Jane Jones. Sue and Bill require full access to all databases in the Sample application. Jane requires full update and calculate access to all databases within the Sample application, but she will not define or maintain database definitions. Users will be added; all will require read access to all databases.

Solution When Using Essbase in Native Security Mode:

Because the current users have differing needs for application and database access, define their permissions individually. Then, to save time assigning individual read permissions for future users, make read the global setting for the application. (It does not matter in what order you assign the user permissions and the global access.)

The Administrator should perform the following tasks:

  1. Set up the users with Administration Services.

    See the Oracle Essbase Administration Services Online Help.

  2. Create or edit Sue and Bill as ordinary users with Application Manager permissions.

    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. Define global read access for the Sample application as the minimum database access setting to give all additional users read access to all databases in the Sample application.

    See “Setting Minimum Permissions for Databases” in the Oracle Essbase Administration Services Online Help.