Note: | This functionality does not apply if Essbase Server is in EPM System security mode. |
If you have Database Manager permissions for a database, you can use a database setting to grant all users a minimum level of permissions for a database. The setting applies to all users of the specific database and overrides application-level permissions. Minimum permissions for a database are overridden by higher permissions granted to individual users and groups.
For example, if the minimum permission for a database is Read but a specific user has Write permission for the database, the user-level permission takes precedence over the database-level permission. The user is able to update data values in the database.
To set the minimum permission for a database:
From Enterprise View or a custom view, select the database.
Right-click and select Edit, then Properties.
In Database Properties , select the General tab.
In Minimum access level, select an access level. For example, to grant all users at least Write access to the database (meaning that all users can update data values), select Write.
The default setting is None, meaning that no minimum permission is set; all users can access the database according to their user-level permissions.
Click Apply.
alter database (MaxL) in the Oracle Essbase Technical Reference