ORA-65096: invalid common user or role name
create user c##username identified by password;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;Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
