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 calculate access to all databases in the Sample application, but she does not need to define or maintain database definitions.
Solution When Using Essbase in Native Security Mode:
The Administrator should perform the following tasks:
Create Sue and Bill as ordinary users with Application Manager permission.
If Sue and Bill are created without Application Manager permission, assign them Application Manager permission.
See Creating Users in Essbase Native Security Mode or Granting Designer Permissions to Users and Groups in Essbase Native Security Mode.
Define global Calculate access for the Sample application as the Minimum Database Access setting to give all additional users Calculate access to all databases for the application.
See “Setting Minimum Permissions for Applications” in the Oracle Essbase Administration Services Online Help.
Create Jane as an ordinary user with no additional permissions. She inherits Calculate access from the application global setting.