MaxL- Create and Add External Directory Users to the Native Groups

Trying to add a number of users from the external directory to the native groups using MaxL.

alter user ‘UserName’ add to group Group_Name;

But the MaxL statement does not recognize the external directory user id as the user still does not have an entry in essbase.sec. This can be achieved by provisioning “Server Access” Role in Shared services. But our requirement is to use maxl to automate this task without using shared services console or CSS API.

How can we make essbase aware of this user id so that we can use MaxL to add the user to different native groups?

By using create user type external, the user id would get added to essbase security file essbase.sec. Then the alter user would recognize the user id so that they can be added to the native groups.

create or replace user ‘essuser@LDAPNAME’ type external;
alter user ‘essuser@LDAPNAME’ add to group essgroup;



Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s