{16 追加}プロキシユーザを用いたスキーマ限定アカウントの接続

 

https://docs.oracle.com/cd/F19136_01/dbseg/configuring-authentication.html#GUID-22328DCF-B137-499B-ACC9-49D6C72B6A57

https://qiita.com/plusultra/items/65ffb3f0282b6335e154

https://docs.oracle.com/cd/F19136_01/dbseg/configuring-authentication.html#GUID-0C753164-99C5-49A6-9EF3-428B187C6511

sqlplus test/test@pdb11

CREATE USER preston NO AUTHENTICATION;
grant create session to preston;

CREATE USER appuser IDENTIFIED BY oracle;
grant create session to appuser;

ALTER USER preston GRANT CONNECT THROUGH appuser;

CONNECT appuser[preston]/oracle@pdb11