Databases Reference
In-Depth Information
Looking at the previous screenshot you can see the choices provided to you for
default access to the Essbase applications or databases. The only difference is if you
set the access at the application level, the user will have the selected level of access
for all databases within the application. If you grant this same level of access at the
database level the ID will have this level of access only at the database level for
which it was given.
Create user
Using the MaxL statement, you can create a new user, assign a default password,
and associate the user with a database access group.
Syntax:
create user <user-name> identified by <password> as <EXISTING
USERNAME> | member of group <group-name>;
Code Sample:
create user essuser identified by essinit member of group esssales;
Alter user
The
alter
MaxL statement lets the administrator edit a user such as: change the
group, remove the user from a group, enable the password, disable the password,
and reset the user.
Syntax:
alter user <user-name> add to group <Group-name>;
/* Adds an
existing user to an access group */
alter user <user-name> remove from group <Group-name>;
/* Removes
an existing user from an access group */
alter user <user-name> rename to <new user-name>;
/* Renames an
existing user to a new user name */
alter user <user-name> enable;
/* Reactivate the user's ID */
alter user <user-name> disable;
/* Disable the user ID */
alter user <user-name> set_password <new-password>;
/* Set a new
password for a specified user ID */
alter user <user-name> set_password_reset_days <integer> days | none
| immediate | exact;
/* Set the password time to live in days */
alter user <user-name> reset;
/* This statement resets the user
ID. If the user ID is locked then it will be unlocked.
Unsuccessful password attempts will set to 0 */
