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 vote113 views1 answer
View to table sql
SQL
0 vote107 views1 answer
Sql reverse order of results
SQL
1 vote103 views2 answers
Regex starts with
SQL
0 vote93 views1 answer
Phpmyadmin mysql conflict
SQL
0 vote101 views1 answer
Insert array into mysql column
SQL
0 vote103 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
2 votes98 views1 answer
Set username and password for postgresql database
SQL
0 vote92 views1 answer
Sqlite to csv statement
SQL
8 votes66 views1 answer
Oracle current date plus 1 month
SQL
0 vote192 views1 answer
Which MySQL data type to use for storing boolean values
SQL