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

Required Oracle Administrator Account Privileges

The Oracle administrator account that you use with CA IdentityMinder is the account name that you enter in the System Logon field of the Endpoint tab of the Oracle Endpoint property sheet.

Give this account at least the following privileges:

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

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

Sufficient privileges to Oracle accounts for packages and procedures

Grant these privileges in ONE of the following ways:

• The account is the owner of these packages and procedures.
• The account has execute privileges with the Admin Option for these packages and procedures.