重庆思庄Oracle、Redhat认证学习论坛

标题: 测试12C中修改CDB级别的密码限制是否影响到PDB [打印本页]

作者: miss_puff 时间: 2017-12-7 11:36
标题: 测试12C中修改CDB级别的密码限制是否影响到PDB
1、查看cdb 密码限制
SQL> show con_name;

CON_NAME
------------------------------
CDB$ROOT
SQL> show pdbs;

CON_ID CON_NAME                      OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
      2 PDB$SEED                      READ ONLY  NO
      3 RACDBPDB                      READ WRITE NO
SQL> set linesize 260
SQL> select profile,resource_name,limit from dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';

PROFILE                               RESOURCE_NAME       LIMIT
---------------------------------------- -------------------- ----------------------------------------
DEFAULT                               PASSWORD_LIFE_TIME 180

SQL>
2、查看pdb密码限制
SQL> show pdbs;

CON_ID CON_NAME                      OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
      2 PDB$SEED                      READ ONLY  NO
      3 RACDBPDB                      READ WRITE NO

SQL> alter session set container=racdbpdb;

Session altered.

SQL> set linesize 260
SQL> select profile,resource_name,limit from dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';

PROFILE                               RESOURCE_NAME       LIMIT
---------------------------------------- -------------------- ----------------------------------------
DEFAULT                               PASSWORD_LIFE_TIME 180

3、修改cdb密码限制
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

Profile altered.

SQL> select profile,resource_name,limit from dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';

PROFILE                               RESOURCE_NAME       LIMIT
---------------------------------------- -------------------- ----------------------------------------
DEFAULT                               PASSWORD_LIFE_TIME UNLIMITED

SQL>

4、再次查看pdb密码限制
SQL> show pdbs;

CON_ID CON_NAME                      OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
      2 PDB$SEED                      READ ONLY  NO
      3 RACDBPDB                      READ WRITE NO
SQL> alter session set container=racdbpdb;

Session altered.

SQL> set linesize 260
SQL> select profile,resource_name,limit from dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';

PROFILE                               RESOURCE_NAME       LIMIT
---------------------------------------- -------------------- ----------------------------------------
DEFAULT                               PASSWORD_LIFE_TIME 180

SQL>

由此可见，在12C中，修改cdb级别的密码限制并不会影响到Pdb。

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)