Create Account

Account

SELECT Permission

Role

Profile

GRANT CONNECT TO ${UserName};

 

 

 

GRANT CREATE ROLE TO ${UserName};

 

 

 

GRANT CREATE PROFILE TO ${UserName};

GRANT CREATE USER TO ${UserName};

GRANT GRANT ANY ROLE TO ${UserName};

GRANT GRANT ANY PRIVILEGE TO ${UserName};

GRANT SELECT ON DBA_TABLESPACES TO ${UserName};

GRANT SELECT ON DBA_PROFILES TO ${UserName};

For the CDB service account, the above permissions must be in the following format:

Connect account

GRANT CONNECT TO <C##username> container=CURRENT;

All other permissions

GRANT CREATE ROLE TO <C##username> container=ALL;