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 vote202 views1 answer
To_date sql
SQL
0 vote208 views3 answers
Postgres date difference seconds
SQL
0 vote210 views1 answer
Oracle winter time change
SQL
3 votes201 views1 answer
Convert sqlite table to pandas dataframe
SQL
20 votes203 views4 answers
Reset auto increment in MySQL
SQL
6 votes236 views1 answer
How to get the size of the database in postgresql
SQL
1 vote202 views1 answer
Describe table in sql
SQL
3 votes200 views2 answers
Sql get month name
SQL
0 vote176 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
0 vote220 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL