Automating your Essbase Cube - Oracle Essbase 9 Implementation Guide - page 308

Code Sample:
alter user 'HYPUSER' add to group ESSPROFIT;
alter user 'HYPUSER" RESET;
Display user
The display user M axL statement will display the user information like username,
last logon date, enables, and password reset days remaining.
Syntax:
display user all | <User-name> | in group (all | <Group-name>);
Code Sample:
display user all;
display user in group all;
display user in group ESSPROFIT;
Drop user
The drop user MaxL statement will delete the existing user.
Syntax:
drop user <user-name>;
Code Sample:
drop user ESSUSER;
Grant user
The grant user MaxL statement will grant permissions to the user.
Syntax:
grant user SYS-SYSTEM-PRIVILEGE | SYS-SYSTEM-ROLE | APP-SYSTEM-ROLE ON
APPLICATION <APP-Name> | GRANTED-DBS-SYSTEM-ROLE ON DATABASE <Db-name>
| FILTER <Filter-name> | EXECUTE <Calc-name> TO <User-name> | <Group-
name>;
Code Sample:
grant user administrator to Sarma;
grant user no_access to Joe;