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

3 votes332 views1 answer
Mysql set field unique
SQL
0 vote332 views1 answer
Sqlite update only if greater
SQL
0 vote384 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote331 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
0 vote345 views1 answer
Add mysql database to power bi web
SQL
5 votes353 views2 answers
Mysqldump password
SQL
0 vote398 views1 answer
Python get backup of sql
SQL
0 vote364 views1 answer
Contraint default SQL
SQL
0 vote351 views1 answer
Postgres get database encoding
SQL
0 vote352 views1 answer
Sqlalchemy empty table
SQL