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 vote271 views1 answer
How to find table lock and row lock in mysql
SQL
0 vote282 views1 answer
Use mysql in java program
SQL
2 votes249 views2 answers
Laravel query builder toSql
SQL
0 vote256 views1 answer
Connect laravel to mysql on mac
SQL
10 votes255 views2 answers
Linux command line import mysql database
SQL
1 vote283 views1 answer
Psql view enum values
SQL
3 votes258 views2 answers
How to start postgresql on windows
SQL
-1 vote275 views4 answers
Sql view postgresql
SQL
0 vote265 views4 answers
Mysql count table rows
SQL
0 vote261 views1 answer
Test database for sql
SQL