创建操作系统用户
使用DBMS_CREDENTIAL软件包为每个容器创建相关的数据库凭据
show pdbs show CON_NAME
BEGIN
DBMS_CREDENTIAL.create_credential(
credential_name => ‘cdb1’,
username => ‘cdb1_zhangsan’,
password => ‘AAbb123’);
END;
/
BEGIN
DBMS_CREDENTIAL.create_credential(
credential_name => ‘pdb2’,
username => ‘pdb2_lisi’,
password => ‘AAbb123’);
END;
/
BEGIN
DBMS_CREDENTIAL.create_credential(
credential_name => ‘pdb3’,
username => ‘pdb3_wangwu’,
password => ‘AAbb123’);
END;
/
检查凭据是否全部存在并由根容器拥有。
SELECT con_id, owner, credential_name
FROM cdb_credentials;
定义容器的默认操作系统凭据
ALTER SYSTEM SET PDB_OS_CREDENTIAL=cdb1_user_cred SCOPE=SPFILE;
SHUTDOWN IMMEDIATE;
CREATE PFILE=‘D:\pfile.txt’ FROM SPFILE;
增加一行
*.pdb_os_credential=cdb1
CREATE SPFILE FROM PFILE=‘D:\pfile.txt’;
STARTUP;
SHOW PARAMETER PDB_OS_CREDENTIAL
ALTER SESSION SET CONTAINER=pdb3;
ALTER SYSTEM SET PDB_OS_CREDENTIAL=pdb3 SCOPE=SPFILE;
SHUTDOWN IMMEDIATE;
STARTUP;
SHOW PARAMETER PDB_OS_CREDENTIAL