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 vote248 views1 answer
Duplix print in Smartforms
SQL
0 vote235 views1 answer
Snap craft
SQL
0 vote182 views1 answer
Mysql collation for all languages
SQL
0 vote245 views1 answer
Sqlalchemy get ids
SQL
21 votes254 views3 answers
Sql server search column name in all tables
SQL
5 votes255 views1 answer
Mysql where one year ago
SQL
0 vote231 views1 answer
Forcefully delete a row in mysql which has references
SQL
3 votes236 views1 answer
Sql server version query
SQL
1 vote254 views1 answer
Where date = max(date) in sql
SQL
0 vote261 views1 answer
SQL-Arten
SQL