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

1 vote163 views1 answer
Postgresql convert text to float
SQL
0 vote170 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote163 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
3 votes170 views1 answer
Make a field auto_increment mysql
SQL
9 votes190 views6 answers
Oracle substring
SQL
2 votes150 views2 answers
How to get capital letter first in sql
SQL
0 vote231 views1 answer
Add computed column to table sql server
SQL
0 vote167 views1 answer
Normalization in database 2nd normal form
SQL
2 votes182 views1 answer
Copy all values of a column to another column in sql in same table
SQL
1 vote170 views1 answer
Spark sql concatenate string and int
SQL