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

5 votes247 views1 answer
Oracle sysdate - 1 month
SQL
0 vote182 views1 answer
How to change mysql root password in windows 10
SQL
0 vote168 views1 answer
Update and keep original value sql
SQL
0 vote195 views1 answer
Primary key start from number
SQL
2 votes193 views1 answer
Removing view
SQL
1 vote190 views1 answer
Tsql random number
SQL
0 vote162 views1 answer
Database springboot
SQL
1 vote211 views1 answer
Mysql print variable
SQL
0 vote175 views1 answer
Implicit inner join table alias with id values
SQL
6 votes179 views2 answers
Stored procedure to delete data from table in mysql
SQL