Mapping sets and object types
The Oracle database template has the following mapping sets:
- Tablespace: Logical storage units that store data of all the databases.
- Users: Users of the database.
- Roles: Provides database security at a basic level.
- Profile: A collection of parameters that set limits on the database resources.
-
RoleInRole: Role membership.
- UserInRoles: User role membership.
-
UserHasTablespace: Permanent tablespace assigned to users.
-
UserHasTempTablespace: Temporary tablespace assigned to users.
NOTE: Before updating the default mapping sets, you should save the backup of the One Identity Manager database.
Mapping object types between Oracle database and One Identity Manager tables
The following table describes how to map object types in the Oracle database to the corresponding UNS tables in One Identity Manager.
Mapping set name |
Oracle objects | One Identity Manager table |
Tablespaces |
sys.dba_tablespaces |
UNSItemB |
Users |
sys.dba_users | UNSAccountB |
Roles |
sys.dba_roles |
UNSGroupB |
Profiles |
sys.dba_profiles | UNSContainerB |
RoleInRole |
sys.dba_role_privs (GROUPINGROUP) | UNSGroupBInUNSGroupB |
UserInRole |
sys.dba_role_privs (USERINROLE) |
UNSAccountBInUNSGroupB (effective assignments) |
UserHasTablespace |
sys.dba_users |
UNSAccountBHasUNSItemB (Tablespace) |
UserHasTempTablespace |
sys.dba_users |
UNSAccountBHasUNSItemB (Temporary Tablespace) |