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 votes181 views3 answers
Postgresql random number
SQL
0 vote183 views1 answer
Write a query to peint the pattern P(20)
SQL
5 votes138 views1 answer
Postgres upsert
SQL
5 votes172 views1 answer
Mysql change primary key
SQL
0 vote181 views1 answer
Sql if else in select
SQL
3 votes238 views1 answer
Query less than datetime sql
SQL
0 vote200 views1 answer
Difference between db.query and db.execute
SQL
0 vote169 views1 answer
Check if table exists oracle
SQL
1 vote241 views1 answer
Continue in sql
SQL
0 vote278 views1 answer
Bigrock database connection string
SQL