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 vote168 views1 answer
Oracle create job if not exists
SQL
0 vote152 views1 answer
Mysql update sum same table
SQL
0 vote169 views1 answer
Permission denied postgres \copy csv command line
SQL
8 votes173 views5 answers
Grant permission in postgres
SQL
1 vote171 views1 answer
How to print longest name in sql
SQL
5 votes191 views1 answer
Oracle add time to date
SQL
0 vote176 views2 answers
Drop tables from local table database postgres
SQL
0 vote127 views1 answer
Mysql insert with foreign key
SQL
0 vote192 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
0 vote183 views1 answer
Mysql command line top 10
SQL