Oracle 12cでプロファイル毎のパスワード有効期限を確認

2021年11月11日

環境
Oracle 12.2.0.1.0

SQL構文

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
SELECT
*
FROM
DBA_PROFILES
WHERE
RESOURCE_NAME = 'PASSWORD_LIFE_TIME';
SELECT * FROM DBA_PROFILES WHERE RESOURCE_NAME = 'PASSWORD_LIFE_TIME';
SELECT
  * 
FROM
  DBA_PROFILES 
WHERE
  RESOURCE_NAME = 'PASSWORD_LIFE_TIME'; 

実行結果

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
PROFILE           RESOURCE_NAME   RESOURCE_TYPE LIMIT  COMMON INHERITED IMPLICIT
DEFAULT           PASSWORD_LIFE_TIME PASSWORD   UNLIMITED  NO   NO      NO
GSM_PROF          PASSWORD_LIFE_TIME PASSWORD   DEFAULT  YES   YES     NO
ORA_STIG_PROFILE PASSWORD_LIFE_TIME PASSWORD    60  NO   NO     NO
PROFILE           RESOURCE_NAME   RESOURCE_TYPE LIMIT  COMMON INHERITED IMPLICIT DEFAULT           PASSWORD_LIFE_TIME PASSWORD   UNLIMITED  NO   NO      NO GSM_PROF          PASSWORD_LIFE_TIME PASSWORD   DEFAULT  YES   YES     NO ORA_STIG_PROFILE PASSWORD_LIFE_TIME PASSWORD    60  NO   NO     NO
PROFILE	          RESOURCE_NAME	  RESOURCE_TYPE  LIMIT	 COMMON   INHERITED	IMPLICIT
DEFAULT	          PASSWORD_LIFE_TIME	    PASSWORD	  UNLIMITED	 NO	  NO     	NO
GSM_PROF          PASSWORD_LIFE_TIME	   PASSWORD	  DEFAULT	 YES     YES	    NO
ORA_STIG_PROFILE	  PASSWORD_LIFE_TIME	  PASSWORD	   60	 NO	  NO	    NO

 

Oracle 12c

Posted by arkgame