Oracle 23c New Features for DBA'sIn 18c, we can create a schema with no password using NO AUTHENTICATION clause, which can be useful in proxy based authentication.
These accounts are called Schema only accounts and not required any authentication mechanism and used only via remote authentication only.
SQL . CREATE USER TEST NO AUTHENTICATION;
However, these accounts cannot directly connect to database, but useful in proxy based connectivity i.e client user only. You can grant privileges to this schema only accounts.
CONN / AS SYSDBA
CREATE USER test_user NO AUTHENTICATION; (earlier we need to provide identified by clause for this)
ALTER USER scott GRANT CONNECT THROUGH test_user;
-Thanks
Suresh
Follow Me!!!