Enterprise Manager Roles

Enterprise Manager is supplied with pre-defined roles. New roles can also be created.

Enterprise Manager roles are configuured using:

Setup -> Security -> Roles

Pre-Defined Roles

In EM 12.1.0.4 there are 36 pre-defined roles

All pre-defined roles are owned by SYSMAN

Repository Tables

MGMT_ROLES

Contains one row for each role

Column Name Data Type Notes
ROLE_NAMEVARCHAR2(256)Role Name
DESCRIPTIONVARCHAR2(4000) 
ROLE_TYPENUMEBR(1) 
ROLE_DESC_NLSIDVARCHAR2(64) 
RESOURCE_BUNDLEVARCHAR(256) 
ROLE_IDRAW(16) 
CREATORVARCHAR2(256) 
EXTERNAL_ROLE_NAMEVARCHAR2(256) 
PRIVATE_ROLENUMBER(1) 
CREATED_BYRAW(16) 
TENANT_IDRAW(16) 

MGMT_ROLE_GRANTS

Contains one row for each grant of a role to a grantee (administrator or another role)

Column Name Data Type Notes
GRANTEEVARCHAR2(256) 
ROLE_NAMEVARCHAR2(256) 
WITH_ADMINNUMBER(1) 
GRANTEE_IS_ROLENUMBER(1)