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 vote150 views2 answers
Generate sql trigger through ef migration
SQL
0 vote225 views1 answer
Mysql update all record removing 2 hours from column
SQL
19 votes144 views6 answers
What is mySQL
SQL
-1 vote154 views1 answer
Mysql change database charset and collation
SQL
0 vote178 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
2 votes154 views2 answers
Postgres add column integer
SQL
0 vote183 views1 answer
Postgres select from values
SQL
0 vote139 views1 answer
Oracle query archivemode
SQL
0 vote169 views1 answer
Pl sql search in all packages
SQL
0 vote147 views1 answer
Database get 10 user aleatory
SQL