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

15 votes158 views4 answers
Mysql export database command line
SQL
0 vote149 views1 answer
Mql5 datetime get hour
SQL
0 vote128 views1 answer
Backup a table in sql
SQL
0 vote131 views1 answer
Create synonym for dblink in oracle
SQL
0 vote136 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
0 vote147 views2 answers
Dumping sql table
SQL
94 votes176 views4 answers
Create database postgres
SQL
1 vote159 views1 answer
Oracle select first row order by
SQL
0 vote231 views1 answer
Mysql select field if condition
SQL
1 vote135 views1 answer
Where not in array sql
SQL