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 vote229 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
0 vote220 views1 answer
How to Remove milliseconds from Date time
SQL
0 vote236 views2 answers
Sql day from datetime
SQL
1 vote203 views1 answer
How to print longest name in sql
SQL
0 vote219 views1 answer
Delete * from where id = 1;
SQL
0 vote233 views1 answer
Oracle 11g forget password
SQL
1 vote234 views1 answer
Isnull sql server
SQL
0 vote207 views1 answer
Backup a table in sql
SQL
3 votes220 views1 answer
Oracle APEX elapsed time
SQL
4 votes217 views1 answer
SQL find text in SP
SQL