set linesize 200
set pages 100
col PROFILE for a20
col LIMIT for a30
SELECT * FROM DBA_PROFILES where PROFILE='DEFAULT' order by PROFILE,RESOURCE_NAME;
PROFILE RESOURCE_NAME RESOURCE LIMIT COM INH IMP
-------------------- -------------------------------- -------- ------------------------------ --- --- ---
DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED NO NO NO
DEFAULT CONNECT_TIME KERNEL UNLIMITED NO NO NO
DEFAULT CPU_PER_CALL KERNEL UNLIMITED NO NO NO
DEFAULT CPU_PER_SESSION KERNEL UNLIMITED NO NO NO
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD UNLIMITED NO NO NO
DEFAULT IDLE_TIME KERNEL UNLIMITED NO NO NO
DEFAULT INACTIVE_ACCOUNT_TIME PASSWORD UNLIMITED NO NO NO
DEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITED NO NO NO
DEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITED NO NO NO
DEFAULT PASSWORD_GRACE_TIME PASSWORD 7 NO NO NO
DEFAULT PASSWORD_LIFE_TIME PASSWORD UNLIMITED NO NO NO
DEFAULT PASSWORD_LOCK_TIME PASSWORD 1 NO NO NO
DEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED NO NO NO
DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED NO NO NO
DEFAULT PASSWORD_ROLLOVER_TIME PASSWORD 0 NO NO NO
DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL NO NO NO
DEFAULT PRIVATE_SGA KERNEL UNLIMITED NO NO NO
DEFAULT SESSIONS_PER_USER KERNEL UNLIMITED NO NO NO
SQL> SELECT * FROM DBA_PROFILES order by PROFILE,RESOURCE_NAME;
PROFILE RESOURCE_NAME RESOURCE LIMIT COM INH IMP
-------------------- -------------------------------- -------- ------------------------------ --- --- ---
DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED NO NO NO
DEFAULT CONNECT_TIME KERNEL UNLIMITED NO NO NO
DEFAULT CPU_PER_CALL KERNEL UNLIMITED NO NO NO
DEFAULT CPU_PER_SESSION KERNEL UNLIMITED NO NO NO
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD UNLIMITED NO NO NO
DEFAULT IDLE_TIME KERNEL UNLIMITED NO NO NO
DEFAULT INACTIVE_ACCOUNT_TIME PASSWORD UNLIMITED NO NO NO
DEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITED NO NO NO
DEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITED NO NO NO
DEFAULT PASSWORD_GRACE_TIME PASSWORD 7 NO NO NO
DEFAULT PASSWORD_LIFE_TIME PASSWORD UNLIMITED NO NO NO
DEFAULT PASSWORD_LOCK_TIME PASSWORD 1 NO NO NO
DEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED NO NO NO
DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED NO NO NO
DEFAULT PASSWORD_ROLLOVER_TIME PASSWORD 0 NO NO NO
DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL NO NO NO
DEFAULT PRIVATE_SGA KERNEL UNLIMITED NO NO NO
DEFAULT SESSIONS_PER_USER KERNEL UNLIMITED NO NO NO
ORA_STIG_PROFILE COMPOSITE_LIMIT KERNEL DEFAULT NO NO NO
ORA_STIG_PROFILE CONNECT_TIME KERNEL DEFAULT NO NO NO
ORA_STIG_PROFILE CPU_PER_CALL KERNEL DEFAULT NO NO NO
ORA_STIG_PROFILE CPU_PER_SESSION KERNEL DEFAULT NO NO NO
ORA_STIG_PROFILE FAILED_LOGIN_ATTEMPTS PASSWORD 3 NO NO NO
ORA_STIG_PROFILE IDLE_TIME KERNEL 15 NO NO NO
ORA_STIG_PROFILE INACTIVE_ACCOUNT_TIME PASSWORD 35 NO NO NO
ORA_STIG_PROFILE LOGICAL_READS_PER_CALL KERNEL DEFAULT NO NO NO
ORA_STIG_PROFILE LOGICAL_READS_PER_SESSION KERNEL DEFAULT NO NO NO
ORA_STIG_PROFILE PASSWORD_GRACE_TIME PASSWORD 5 NO NO NO
ORA_STIG_PROFILE PASSWORD_LIFE_TIME PASSWORD 60 NO NO NO
ORA_STIG_PROFILE PASSWORD_LOCK_TIME PASSWORD UNLIMITED NO NO NO
ORA_STIG_PROFILE PASSWORD_REUSE_MAX PASSWORD 10 NO NO NO
ORA_STIG_PROFILE PASSWORD_REUSE_TIME PASSWORD 365 NO NO NO
ORA_STIG_PROFILE PASSWORD_ROLLOVER_TIME PASSWORD DEFAULT NO NO NO
ORA_STIG_PROFILE PASSWORD_VERIFY_FUNCTION PASSWORD ORA12C_STIG_VERIFY_FUNCTION NO NO NO
ORA_STIG_PROFILE PRIVATE_SGA KERNEL DEFAULT NO NO NO
ORA_STIG_PROFILE SESSIONS_PER_USER KERNEL DEFAULT NO NO NO
RDSADMIN COMPOSITE_LIMIT KERNEL UNLIMITED NO NO NO
RDSADMIN CONNECT_TIME KERNEL UNLIMITED NO NO NO
RDSADMIN CPU_PER_CALL KERNEL UNLIMITED NO NO NO
RDSADMIN CPU_PER_SESSION KERNEL UNLIMITED NO NO NO
RDSADMIN FAILED_LOGIN_ATTEMPTS PASSWORD 10 NO NO NO
RDSADMIN IDLE_TIME KERNEL UNLIMITED NO NO NO
RDSADMIN INACTIVE_ACCOUNT_TIME PASSWORD UNLIMITED NO NO NO
RDSADMIN LOGICAL_READS_PER_CALL KERNEL UNLIMITED NO NO NO
RDSADMIN LOGICAL_READS_PER_SESSION KERNEL UNLIMITED NO NO NO
RDSADMIN PASSWORD_GRACE_TIME PASSWORD 7 NO NO NO
RDSADMIN PASSWORD_LIFE_TIME PASSWORD UNLIMITED NO NO NO
RDSADMIN PASSWORD_LOCK_TIME PASSWORD 1 NO NO NO
RDSADMIN PASSWORD_REUSE_MAX PASSWORD UNLIMITED NO NO NO
RDSADMIN PASSWORD_REUSE_TIME PASSWORD UNLIMITED NO NO NO
RDSADMIN PASSWORD_ROLLOVER_TIME PASSWORD 0 NO NO NO
RDSADMIN PASSWORD_VERIFY_FUNCTION PASSWORD NULL NO NO NO
RDSADMIN PRIVATE_SGA KERNEL UNLIMITED NO NO NO
RDSADMIN SESSIONS_PER_USER KERNEL UNLIMITED NO NO NOConfirm User Lock
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY/MM/DD HH24:MI:SS';
set linesize 200
col USERNAME for a30
SELECT username, account_status, lock_date, expiry_date FROM dba_users;
USERNAME ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE
------------------------------ -------------------------------- ------------------- -------------------
XS$NULL EXPIRED & LOCKED 2024/10/18 02:59:38 2024/10/18 02:59:38
OUTLN LOCKED 2024/10/18 03:20:44
SYS OPEN
SYSTEM OPEN
APPQOSSYS LOCKED 2024/10/18 03:20:44
DBSFWUSER LOCKED 2024/10/18 03:20:44
GGSYS LOCKED 2024/10/18 03:20:44
ANONYMOUS EXPIRED & LOCKED 2024/10/18 03:20:44 2024/10/18 03:20:44
CTXSYS LOCKED 2024/10/18 03:20:44
GSMADMIN_INTERNAL LOCKED 2024/10/18 03:20:44
XDB LOCKED 2024/10/18 03:20:44
DBSNMP LOCKED 2024/10/18 03:20:44
GSMCATUSER LOCKED 2024/10/18 03:20:44
REMOTE_SCHEDULER_AGENT LOCKED 2024/10/18 03:20:44
ADMIN OPEN
SYSBACKUP LOCKED 2024/10/18 03:20:44
GSMUSER LOCKED 2024/10/18 03:20:44
SYSRAC LOCKED 2024/10/18 03:20:44
AUDSYS LOCKED 2024/10/18 03:20:44
DIP LOCKED 2024/10/18 03:20:44
SYSKM LOCKED 2024/10/18 03:20:44
SYS$UMF LOCKED 2024/10/18 03:20:44
SYSDG LOCKED 2024/10/18 03:20:44
RDSADMIN OPEN
24 rows selected.SQL> ALTER USER TEST PASSWORD EXPIRE;
SQL> SELECT username, account_status, lock_date, expiry_date FROM dba_users;
USERNAME ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE
------------------------------ -------------------------------- ------------------- -------------------
TEST EXPIRED 2025/06/26 00:15:56
$ sqlplus TEST/**********@xxxxxx.rds.amazonaws.com:1521/orcl
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jun 26 00:16:21 2025
Version 19.18.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
ERROR:
ORA-28001: the password has expired
Changing password for TEST
New password:
Retype new password:
Password changed
Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.25.0.0.0How to Change Password at Master User
How do I reset the admin user password for my Amazon RDS DB instance?
or
SQL> password
Changing password for ADMIN
Old password:
New password:
Retype new password:
Password changed
SQL> ALTER USER admin IDENTIFIED BY ********;
User altered.
コメント