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

9 votes161 views6 answers
Check constraint in sql
SQL
0 vote170 views3 answers
Join
SQL
0 vote198 views1 answer
Varchar2 length in oracle
SQL
1 vote147 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
2 votes155 views1 answer
Postgresql create table as select
SQL
0 vote166 views1 answer
Replace string in whole database mysql stackoverflow
SQL
4 votes155 views1 answer
Group by mysql and concatenate string
SQL
51 votes254 views6 answers
Opera gx
SQL
1 vote178 views1 answer
Cannot drop database because it is currently in use
SQL
1 vote144 views1 answer
Mysql current time
SQL