Database Reference
In-Depth Information
So let's test the profile and password function.
SQL> sho user
USER is "SYS"
SQL> create user pwtest identified by lowsec;
User created.
SQL> grant create session to pwtest;
Grant succeeded.
sqlplus pwtest/lowsec@192.168.1.3/pdborcl
SQL*Plus: Release 12.1.0.1.0 Production on Thu Aug 15 12:07:08 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> alter user pwtest identified by a;
User altered.
SQL> alter user pwtest identified by a;
alter user pwtest identified by a
*
ERROR at line 1:
ORA-28221: REPLACE not specified
SQL> alter user pwtest identified by a replace a;
alter user pwtest identified by a replace a
*
ERROR at line 1:
ORA-28003: password verification for the specified password failed
ORA-20001: Password length less than 8
SQL> set wrap off
SQL> select * from USER_PASSWORD_LIMITS;
RESOURCE_NAME LIMIT
-------------------------------- -----------------------------------------------
FAILED_LOGIN_ATTEMPTS 10
PASSWORD_LIFE_TIME 180
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_VERIFY_FUNCTION ORA12C_VERIFY_FUNCTION
PASSWORD_LOCK_TIME 1
PASSWORD_GRACE_TIME 7
