1sqlplus / as sysdba
2ALTER SESSION SET "_ORACLE_SCRIPT"=true; -- Warning !
3-- c## prefixe
4CREATE USER c##username IDENTIFIED BY "my_password";
5GRANT CONNECT TO MY_USER; -- To connect to DB
6GRANT RESOURCE TO MY_USER; -- Access / modify
7GRANT MY_ROLE TO MY_USER; -- Grants a role (to be defined)
8GRANT CREATE SESSION TO MY_USER;