Question about user creation on start-up

[cstmgl]

Hi all,
I've read the documentation and examples and I thought I understood it, but I guess not.
I'm trying to create users in different ways.

I'm using this in Openshift but I don't think that is relevant, still...

First using the APPL_USER environment

          env:
            - name: ORACLE_PASSWORD
              value: xyz
            - name: APP_USER
              value: DFLOW
            - name: APP_USER_PASSWORD
              value: xyz

Somehow, I don't think this is being picked up because I don't see it on my logs when the container starts.

Fixed Size 9685328 bytes
Variable Size 570425344 bytes
Database Buffers 654311424 bytes
Redo Buffers 7090176 bytes
Database mounted.
Database opened.
CONTAINER: Resetting SYS and SYSTEM passwords.
User altered.
User altered.
Session altered.
User created.
Grant succeeded.
CONTAINER: Executing user defined scripts...
CONTAINER: running /container-entrypoint-initdb.d/001_create_user.sql ...
Session altered.
User created.
Grant succeeded.
Grant succeeded.
CONTAINER: DONE: running /container-entrypoint-initdb.d/001_create_user.sql
CONTAINER: DONE: Executing user defined scripts.
#########################
DATABASE IS READY TO USE!
#########################

So, we can also see that it does pickup my users from the script.

It's not exactly like the example, but I have this:

ALTER SESSION SET CONTAINER=XEPDB1;

CREATE USER DFLOWX IDENTIFIED BY dataflow QUOTA UNLIMITED ON USERS;

GRANT CONNECT, RESOURCE TO DFLOWX;

GRANT ALL PRIVILEGES TO DFLOWX;

But my problem is that I cannot connect to the db with sqlplus using my user.
And if I connect to it with sqlplus and the SYSTEM user and select username from all_users I don't get the user there.

SQL> select username from all_users;

USERNAME
--------------------------------------------------------------------------------
SYS
AUDSYS
SYSTEM
SYSBACKUP
SYSDG
SYSKM
SYSRAC
OUTLN
GSMADMIN_INTERNAL
GSMUSER
GSMROOTUSER

USERNAME
--------------------------------------------------------------------------------
DIP
XS$NULL
REMOTE_SCHEDULER_AGENT
DBSFWUSER
ORACLE_OCM
SYS$UMF
DGPDB_INT
DBSNMP
APPQOSSYS
GSMCATUSER
GGSYS

USERNAME
--------------------------------------------------------------------------------
XDB
ANONYMOUS
CTXSYS
DVSYS
MDSYS
MDDATA
LBACSYS
DVF
OPS$ORACLE
DFLOW1

32 rows selected.

As you can see my user is not created. However, I can create a similar user from SQL plus (as I did user DFLOW1)
If I try to create any user with the same name as APPL_USER or as I define in my SQL I cannot do it because I get this error.

SQL> CREATE USER DFLOW IDENTIFIED BY dataflow QUOTA UNLIMITED ON USERS;
CREATE USER DFLOW IDENTIFIED BY dataflow QUOTA UNLIMITED ON USERS
*
ERROR at line 1:
ORA-65048: error encountered when processing the current DDL statement in
pluggable database XEPDB1
ORA-01920: user name 'DFLOW' conflicts with another user or role name

This leads me to believe the users might have been created somewhere else or stuck in some limbo. Can someone give me some pointers? Maybe this is just a fundamental lack of know-how on Oracle on my side.

I could use the script for create user, I could do this after the container starts, but I think it would not do what I need because it's missing some of the privileges.

sh-4.4$ ./createAppUser DFLOW2 DFLOW
Session altered.
User created.
Grant succeeded.

I also can't login even with this user:

Enter user-name: DFLOW2
Enter password: 
ERROR:
ORA-01017: invalid username/password; logon denied

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
sh-4.4$ 

And after I select from the table is nothing there.

I think this might just be my issue, if I select from sqlplus I get:

SQL> Select name from V$Database;

NAME
---------
XE

SQL> 

I was expecting XEPDB1

[cstmgl]

I guess I figured out the problem is that by default the sql plus always connect to XE instead of XEPDB1

If I connect to XEPDB1 I see all my users there...

sh-4.4$ sqlplus SYSTEM/xyz@//localhost/XEPDB1

SQL*Plus: Release 21.0.0.0.0 - Production on Tue Nov 22 09:36:25 2022
Version 21.3.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.

Last Successful login time: Tue Nov 22 2022 09:35:25 +00:00

Connected to:
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0

SQL> select username from all_users;

USERNAME
--------------------------------------------------------------------------------
SYS
....

DFLOW
DFLOW1
DFLOW2

37 rows selected.

SQL>