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

0 vote266 views1 answer
Mysql select last 15 minutes
SQL
0 vote285 views1 answer
Mysql query to check record exists in database table or not
SQL
0 vote277 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL
1 vote283 views1 answer
Mysql workbench in ubuntu 14.04
SQL
0 vote259 views1 answer
Mysql autoincrement valor inicial
SQL
0 vote267 views1 answer
Oracle last character of string
SQL
0 vote265 views1 answer
Mysql function variable
SQL
36 votes345 views6 answers
Change column data type sql
SQL
0 vote460 views1 answer
Dublicate row sql
SQL
10 votes232 views1 answer
Oracle view dependencies
SQL