Hi,
With a connection to a pluggable database/system user, I created a developer user with the following privileges:
System Privileges:
Create procedure
Create sequence
Create Session
Create Table
Create Trigger
Create View
Unlimited Tablespace
In SQL-PLUS, user SYSTEM I switch my session to the pluggable database with the following statement:
alter session set container = xepdb1;
After I did run the following sql statement to check the new user khristine, as follows:
SQL> select substr(username,1,10), user_id, created, substr(default_collation,1,10)
from all_users
where username like 'khr%';
The query outcome is as follows:
SUBSTR(USERNAME,1,10) USER_ID CREATED SUBSTR(DEFAULT_COLLATION,1,10)
---------------------------------------- ---------- --------- ----------------------------------------
khristine 105 21-DEC-20 USING_NLS_
If I try to connect with sql-plus, I got the following messageI ORA-01017: invalid username/password; logon denied :
If I try to create a new connection in SQL Developer with the new local user, but it doesn't work:
Could you please let me know what is wrong, what step is missing?
Thanks in advance,
Khristine