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 vote149 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
0 vote121 views1 answer
Get employees if not contains in sql
SQL
0 vote122 views1 answer
Sql server concat null
SQL
79 votes210 views6 answers
Grepper code
SQL
7 votes126 views2 answers
3rd height salary sql
SQL
0 vote75 views1 answer
Mitigation of sql injection
SQL
2 votes120 views1 answer
Cast string to datetime mysql
SQL
0 vote71 views1 answer
Sql server is not
SQL
0 vote124 views1 answer
Match end of string regex sql
SQL
-1 vote115 views1 answer
Insert results of a stored procedure into a temporary table
SQL