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 votes153 views1 answer
Oracle list dates without weekends
SQL
11 votes150 views1 answer
Mysql order by two columns priority
SQL
1 vote158 views1 answer
Sql server cast date dd/mm/yyyy
SQL
0 vote171 views1 answer
Snowflake drop column
SQL
0 vote162 views1 answer
Get record which is available in one table but not in another mysql
SQL
0 vote149 views1 answer
Sql delete where x or y or z
SQL
0 vote149 views2 answers
Imageview setimageresource null
SQL
1 vote150 views1 answer
Oracle sql listagg
SQL
1 vote149 views1 answer
Mysql history command
SQL
0 vote165 views1 answer
SQL: calculate hours from two dates
SQL