Oracle 18c xe ORA-65096

ORA-65096: invalid common user or role name

create user c##username identified by password;

Oracle 18c xe ORA-65096

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

Similar codes

2 votes345 views2 answers
How to get capital letter first in sql
SQL
0 vote389 views1 answer
Cube oracle
SQL
2 votes362 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
3 votes337 views3 answers
Sql current year
SQL
6 votes350 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
0 vote376 views1 answer
How to make case insensitive in sql
SQL
13 votes369 views1 answer
Sql join 3 tables on id
SQL
14 votes359 views6 answers
Auto_increment mysql
SQL
0 vote387 views1 answer
Mysql edit trigger
SQL
0 vote348 views1 answer
Group by sql not ordering issues
SQL