If you have Application Manager permissions for an application, you can use an application-level setting to grant all users a minimum level of permissions to all databases in the application. The setting applies to all users and to all databases within the application, unless a higher permission is granted to a specific database or to a specific user or group.
For example, assume that an application contains two databases and that the minimum permission for the application containing the databases is Write. If you change the minimum permission for one database to Calculate, all users can execute calculations on that database, but the minimum permission for the other database remains at Write—the lower, application-level setting.
Likewise, if the minimum permission for an application is Read, but a specific user has Write permission for the same application, the user-level permission takes precedence over the application-level permission.
To set the minimum permission for an application:
From Enterprise View or a custom view, select the application.
Right-click and select Edit properties.
In the Application Properties window, select the General tab.
For the Minimum access level option, select an access level.
For example, if you want all users to have at least Write access to all databases in the application (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 application according to their user-level permissions.
Click Apply.
alter application (MaxL) in the Oracle Essbase Technical Reference
setappstate (ESSCMD) in the Oracle Essbase Technical Reference