Note: | This functionality does not apply if Essbase Server is in EPM System security mode. |
If you have permissions to Create/Delete Users and Groups, you can copy one or more groups from one Essbase Server to another. Also, through copying an existing group, you can create a new group based on the properties of an existing group.
You can copy groups as described in this topic or by migrating all groups from one Essbase Server to another as part of application migration. See Migration Wizard. Security permissions are copied differently depending on the copy method you use.
When copying a group to a different Essbase Server from the Groups window (as described in this topic), keep in mind the following information:
You need Create/Delete Users and Groups permissions for the target server.
Before copying a group from one server to another, ensure that the target server is running.
On the target server, the group is assigned the same group type as the source server (either Administrator or User). For example, if the group has permissions to Create/Delete Users and Groups and/or Create/Delete Applications on the source server, those permissions are carried over to the target server. The group is not granted permissions to applications and databases on the target server. This safeguard prevents the group from being granted inappropriate permissions on the target.
If the group does not exist on the target server and if users in the group do not exist on the target, the group and its users are copied to the target, and the users are assigned to the group.
If a user in the group being copied exists on the target server, the existing user is not assigned to the copied group on the target server. This safeguard prevents existing users from being assigned to the wrong group inadvertently.
If a user in the group being copied exists on the target server, the existing user is not replaced with the user in the group being copied.
If the group being copied exists on the target server, the existing group is replaced with the copied group only if the Replace existing group option is selected. Users in the group are not replaced.
To copy a group to Essbase Server:
From Enterprise View or a custom view, under the appropriate Essbase Server, expand the Security node.
Under the Security node, double-click the Groups node.
In the Groups window, select the group or multiple groups that you want to copy.
Right-click and select Copy group(s).
In the Copy Group dialog box, select the Essbase Server to which you want to copy the group(s).
If you are copying multiple groups, the Essbase Server that you select must be different than the existing Essbase Server.
If you are copying a single group, you can enter a name for the new group in the New group name text box.
If you are copying multiple groups, select Execute in the background if you want to continue working in Administration Services Console during the copy process.
If you are copying multiple groups, select Copy Administrators if you want to copy groups with Administrator permissions.
Select Replace existing group(s), if you want the new group(s) to replace existing group(s) with the same name.
Click OK.
Essbase copies the group(s).
After copying, edit a group's properties on the target server to change any of the following security properties:
Change the group type
Grant permissions for specific applications and databases to the new group
Manage the group's membership
“User Management and Security in Essbase Native Security Mode” in the Oracle Essbase Database Administrator's Guide
create group (MaxL) in the Oracle Essbase Technical Reference