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

6 votes107 views1 answer
Postgres get size of database
SQL
4 votes119 views1 answer
Adding data to table in sql python
SQL
0 vote101 views1 answer
INSERT INTO table using OpenQuery
SQL
0 vote121 views2 answers
Sql 2 way of select unique
SQL
3 votes106 views2 answers
Postgresql remove not null constraint
SQL
0 vote131 views1 answer
Migrations.RunSQL
SQL
2 votes114 views1 answer
Express api ith mysql data
SQL
0 vote126 views1 answer
Selecting Multiple Columns in SQL
SQL
1 vote121 views1 answer
Sql first day quarter
SQL
27 votes227 views3 answers
Mysql delete row
SQL