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 vote138 views1 answer
Implizite joins sql
SQL
0 vote168 views1 answer
Mysql preg replace
SQL
-1 vote156 views1 answer
Pl sql drop trigger
SQL
2 votes166 views1 answer
Sql missing records from another table
SQL
12 votes139 views4 answers
How to take database dump in postgresql
SQL
0 vote147 views1 answer
Mysql url data type
SQL
2 votes141 views2 answers
Run mysql command from bash
SQL
2 votes146 views1 answer
Mariadb select multiple rows into one column
SQL
0 vote123 views1 answer
SQL division of an integer by another integer get float CAST
SQL
3 votes134 views1 answer
Sql multiple column index
SQL