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

1 vote272 views1 answer
Delete triger pl pg sql
SQL
0 vote285 views1 answer
Python mysql executemany
SQL
3 votes267 views1 answer
System.debug apex
SQL
53 votes592 views6 answers
How to install mysql ubuntu
SQL
0 vote279 views1 answer
Django mysqlclient connection string
SQL
2 votes324 views2 answers
Mysql does sentence contain word
SQL
3 votes256 views1 answer
If 0 return null else return query mysql
SQL
4 votes284 views1 answer
Adding data to table in sql python
SQL
1 vote340 views1 answer
Sql server set variable if exists
SQL
0 vote299 views1 answer
How to print mysql query of codeigniter query builder
SQL