Skip to content

set the operating system user for a PDB

set the operating system user for a PDB published on Комментариев к записи set the operating system user for a PDB нет

To set the operating system user for a PDB:
1. Log in to the root as a user and execute the DBMS_CREDENTIAL.CREATE_CREDENTIAL procedure to create an Oracle credential for the $user operating system user:

begin
		 DBMS_CREDENTIAL.CREATE_CREDENTIAL (credential_name => 'CDB1_PDBSW_BUSH'
              , username =>'bush'
              , password => 'passwd');
end;
/

PL/SQL procedure successfully completed.

2. Connect to the PDB to set the PDB_OS_CREDENTIAL to the new credential:

11:18:46 (1)[CDB$ROOT]sys@orcl> alter session set container=SW;
11:19:00 (1)[SW]sys@orcl>  ALTER SYSTEM SET PDB_OS_CREDENTIAL=CDB1_PDBSW_BUSH SCOPE=spfile;

3. Restart the CDB instance.
4. Test the connection as bush:

     $ sqlplus sys@pdb1 as sysdba 

not working =(
ps:
PDB_OS_CREDENTIAL
Undocumented
Per feedback by the Multitenant team:
Not functional in Oracle 12.1.0.2
May be functional with a future PSU allwoing then OS user verfication/validation for PDBs

Primary Sidebar