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

2 votes302 views3 answers
Row number mysql
SQL
8 votes259 views1 answer
Alter tablespace add datafile
SQL
0 vote288 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
61 votes438 views6 answers
Mysql add column
SQL
0 vote264 views1 answer
RowDataPacket
SQL
0 vote313 views1 answer
Mysql convert charset
SQL
2 votes274 views1 answer
Add default sql server
SQL
0 vote285 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
0 vote264 views1 answer
Find largest table in mysql database
SQL
4 votes272 views3 answers
Drop Table Oracle
SQL