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 vote291 views1 answer
Sql how to duplicate a table
SQL
1 vote305 views1 answer
Mysql search like order by best match
SQL
0 vote303 views1 answer
Add mysql database to power bi web
SQL
17 votes350 views4 answers
Show all tables in oracle
SQL
0 vote334 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
0 vote335 views1 answer
Why do we need data structure in sql
SQL
4 votes346 views4 answers
Check constraint in ms sql
SQL
1 vote284 views1 answer
Count mysql server db tables
SQL
0 vote282 views1 answer
Oracle show running job
SQL
1 vote285 views1 answer
Sql first
SQL