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 vote120 views1 answer
Top 3 salary in sql
SQL
1 vote120 views1 answer
Give a column name to values generated from case statement in sql
SQL
0 vote75 views1 answer
How to fetch highest score in minimum time using mysql
SQL
2 votes76 views1 answer
Sql float to int
SQL
0 vote115 views1 answer
Mysql DDL
SQL
0 vote92 views1 answer
Sql injection mitigation
SQL
10 votes125 views2 answers
Rtrim sql
SQL
0 vote159 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
1 vote131 views1 answer
Alter database datafile maxsize 32g
SQL
1 vote103 views1 answer
Sql auto timestamp
SQL