Essbase MaxL Command To Add Databases To Groups


Use MaxL command “Grant” to add databases to a group.

Below is the information from the Technical Reference online documentation.

http://download.oracle.com/docs/cd/E10530_01/doc/epm.931/html_esb_techref/techref.htm

Grant a permission, a filter or a stored calculation to a user or a group.

Granting permissions:

At each level (system, application or database) existing roles are replaced. However, the built-in privileges create_user and create_application are not replaced.

After granting a permission to a user or group, it can be revoked by subsequently granting no_access. However, to prevent users from being able to load the application, you should also grant no_access at the application level.

Granting filters:

There may be only one filter per user per database. Therefore, granting a filter replaces any filters the user may already have on that database.

After granting permissions using a filter, the filter permission can be revoked by subsequently granting no_access to the database. However, to prevent users from being able to load the application, you should also grant no_access at the application level.

Granting calculations:

A user or group may have any number of calculations per database. Therefore, granting a calculation adds it to the user or group’s list of calculations. Grant execute any gives the user or group permission to execute all calculations, including the default calculation.

After granting execute permission, the permission can be revoked by subsequently granting no_access to the database. However, to prevent users from being able to load the application, you should also grant no_access at the application level.

grant no_access to NewGroup;
grant administrator to TestUser;
grant manager on application Sample to TestUser;
grant read on database Sample.basic to TestUser;
grant filter Sample.basic.filter8 to TestUser;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s