Hello,
I'm using oracle 18c XE
With SQL Developper, I created a user:
--------------------------------------------------------------
-- connexion with SYSTEM
--Afficher le nom du container
show con_name
--Connexion a la PDB: XEPBD1
alter session set container=XEPDB1;
--Creation of tablespaces
CREATE TABLESPACE MAXIMO_DB DATAFILE 'E:\Oracle\oradata\CMPMAXP\MAXIMO_DB01.dbf' SIZE 500M EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO ;
CREATE TABLESPACE MAXIMO_IX DATAFILE 'E:\Oracle\oradata\CMPMAXP\MAXIMO_IX01.dbf' SIZE 500M EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO ;
CREATE TABLESPACE TMP01 DATAFILE 'E:\Oracle\oradata\CMPMAXP\TEMP01.dbf' SIZE 500M ;
--Creation of temporary tablespacee CMPMAXP
CREATE TEMPORARY TABLESPACE TMP01 TEMPFILE 'E:\Oracle\oradata\CMPMAXP\TEMP01.dbf' SIZE 5M AUTOEXTEND ON;
drop user maximo cascade;
--Creation of user : maximo
create user maximo identified by maximo default tablespace MAXIMO_DB temporary tablespace TMP01;
grant create job to maximo;
grant create trigger to maximo;
grant create session to maximo;
grant create sequence to maximo;
grant create synonym to maximo;
grant create table to maximo;
grant create view to maximo;
grant create procedure to maximo;
grant alter session to maximo;
grant execute on ctxsys.ctx_ddl to maximo;
grant dba to maximo;
alter user maximo quota unlimited on MAXIMO_DB;
-------------------------------------------------
but I can not connect using maximo
E:\Oracle\dbhomeXE\bin>sqlplus maximo/maximo@xe
SQL*Plus: Release 18.0.0.0.0 - Production on Mer. Juin 23 09:30:35 2021
Version 18.4.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
ERROR:
ORA-01017: nom utilisateur/mot de passe non valide ; connexion refusÚe
---------------------------------------
Is it a limitation of Oracle 18c XE ?
Could you help mr ?
Thank you.