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;