Connector Guides › Connectors Guide › Connecting to Endpoints › Oracle Connector › Connector-Specific Features › Required Oracle Administrator Account Privileges

Required Oracle Administrator Account Privileges

The Oracle administrator account that you use with CA Identity Manager is the account name that you enter in the System Logon field of the Endpoint tab of the Oracle Endpoint property sheet. This account requires the following minimum privileges to take full advantage of the Oracle Connector:

• The following system privileges:

  Alter Profile
  Alter Any Role
  Alter User
  Create Profile
  Create Role
  Create Session
  Create User
  Drop Profile
  Drop User
  Drop Any Role
  Grant Any Privilege
  Grant Any Role

• The SELECT object privilege on the following views in the SYS schema:

  DBA_OBJECTS
  DBA_PROFILES
  DBA_ROLES
  DBA_ROLE_PRIVS
  DBA_TABLESPACES
  DBA_TAB_PRIVS
  DBA_TS_QUOTAS
  DBA_USERS

To grant privileges to Oracle accounts for packages and procedures, ensure that the account name specified in the Logon field of the Oracle Endpoint property sheet is either:

• The owner of these packages and procedures
• Has execute privileges with "Admin Option" for these packages and procedures