An account used for Core-based application connectivity must be granted the following role membership and privileges:
-
Membership of SELECT_CATALOG_ROLE database role.
-
Membership of CLIENTGP database role.
-
The CREATE ANY INDEX privilege.
-
The ALTER ANY INDEX privilege.
-
The DROP ANY INDEX privilege.
-
The CREATE ANY TABLE privilege.
-
The ALTER ANY TABLE privilege.
-
The DROP ANY TABLE privilege.
-
The CREATE ANY VIEW privilege.
-
The DROP ANY VIEW privilege
-
The GRANT ANY OBJECT PRIVILEGE privilege.
-
The CREATE SESSION privilege.
-
The SELECT ANY SEQUENCE privilege.
-
The CREATE ANY SEQUENCE privilege.