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
Create date sql
SQL
4 votes117 views3 answers
Mysql varchar length
SQL
0 vote141 views1 answer
Php get closest location by latitude longitude
SQL
3 votes122 views1 answer
Pl sql check if variable is empty
SQL
0 vote134 views1 answer
Where date major today mysql
SQL
1 vote131 views1 answer
Mysql view curren querys
SQL
0 vote126 views1 answer
Check index sql server
SQL
0 vote129 views1 answer
Postgres type equivalent to timespan c#
SQL
-1 vote163 views1 answer
Mysql faster insert
SQL
0 vote140 views1 answer
Mysql update set sum
SQL