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 votes259 views1 answer
Pl sql asynchronous procedure calls
SQL
2 votes276 views3 answers
Mysql cheat sheet
SQL
3 votes194 views2 answers
Current year sql
SQL
36 votes317 views6 answers
Change column data type sql
SQL
0 vote197 views1 answer
Mysql undo delete
SQL
0 vote202 views1 answer
Power query datetime to date
SQL
0 vote201 views7 answers
Les jointures sql server
SQL
0 vote248 views1 answer
Oracle sql date winter time
SQL
1 vote231 views3 answers
Epoch to datetime
SQL
3 votes205 views5 answers
Sql select
SQL