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 vote310 views1 answer
T sql cursor tr
SQL
0 vote306 views1 answer
Run mssql server terminal
SQL
3 votes324 views1 answer
Locate sql server
SQL
3 votes348 views1 answer
Where id is in list sql
SQL
0 vote334 views1 answer
Mysql case when on date
SQL
1 vote311 views1 answer
Change old domain to new domain name wordpress
SQL
0 vote337 views1 answer
Time data type in mysql
SQL
45 votes376 views5 answers
Grant all privileges mysql
SQL
3 votes286 views1 answer
Oracle detect invalid password
SQL
7 votes318 views3 answers
Foreign key oracle
SQL