PASSWORD_REUSE_TIME – Rodrigo Silva e Silva

SQL> create user rsilva identified by password;
create user rsilva identified by password
*
ERROR at line 1:
ORA-28003: password verification for the specified password failed
ORA-20023: Password must contain at least 2 uppercase character(s)

1

2

3

4

5

6

SQL> create user rsilva identified by password;

create user rsilva identified by password

*

ERROR at line 1:

ORA-28003: password verification for the specified password failed

ORA-20023: Password must contain at least 2 uppercase character(s)

SQL> alter profile default limit password_verify_function null;

1	SQL> alter profile default limit password_verify_function null;

SQL> alter profile DEFAULT limit PASSWORD_REUSE_TIME UNLIMITED;

1	SQL> alter profile DEFAULT limit PASSWORD_REUSE_TIME UNLIMITED;

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_REUSE_MAX UNLIMITED;

1	SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_REUSE_MAX UNLIMITED;

SQL> select * from dba_profiles where profile='DEFAULT';

PROFILE         RESOURCE_NAME                RESOURCE LIMIT      COM INH IMP
--------------- ---------------------------- -------- ---------- --- --- ---
DEFAULT         COMPOSITE_LIMIT              KERNEL   UNLIMITED  NO  NO  NO
DEFAULT         SESSIONS_PER_USER            KERNEL   UNLIMITED  NO  NO  NO
DEFAULT         CPU_PER_SESSION              KERNEL   UNLIMITED  NO  NO  NO
DEFAULT         CPU_PER_CALL                 KERNEL   UNLIMITED  NO  NO  NO
DEFAULT         LOGICAL_READS_PER_SESSION    KERNEL   UNLIMITED  NO  NO  NO
DEFAULT         LOGICAL_READS_PER_CALL       KERNEL   UNLIMITED  NO  NO  NO
DEFAULT         IDLE_TIME                    KERNEL   UNLIMITED  NO  NO  NO
DEFAULT         CONNECT_TIME                 KERNEL   UNLIMITED  NO  NO  NO
DEFAULT         PRIVATE_SGA                  KERNEL   UNLIMITED  NO  NO  NO
DEFAULT         FAILED_LOGIN_ATTEMPTS        PASSWORD 3          NO  NO  NO
DEFAULT         PASSWORD_LIFE_TIME           PASSWORD 60         NO  NO  NO

PROFILE         RESOURCE_NAME                RESOURCE LIMIT      COM INH IMP
--------------- ---------------------------- -------- ---------- --- --- ---
DEFAULT         PASSWORD_REUSE_TIME          PASSWORD UNLIMITED  NO  NO  NO
DEFAULT         PASSWORD_REUSE_MAX           PASSWORD UNLIMITED  NO  NO  NO
DEFAULT         PASSWORD_VERIFY_FUNCTION     PASSWORD NULL       NO  NO  NO
DEFAULT         PASSWORD_LOCK_TIME           PASSWORD 1          NO  NO  NO
DEFAULT         PASSWORD_GRACE_TIME          PASSWORD 7          NO  NO  NO
DEFAULT         INACTIVE_ACCOUNT_TIME        PASSWORD UNLIMITED  NO  NO  NO

17 rows selected.

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

SQL> select * from dba_profiles where profile='DEFAULT';

PROFILE RESOURCE_NAME RESOURCE LIMIT COM INH IMP

--------------- ---------------------------- -------- ---------- --- --- ---

DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED NO NO NO

DEFAULT SESSIONS_PER_USER KERNEL UNLIMITED NO NO NO

DEFAULT CPU_PER_SESSION KERNEL UNLIMITED NO NO NO

DEFAULT CPU_PER_CALL KERNEL UNLIMITED NO NO NO

DEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITED NO NO NO

DEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITED NO NO NO

DEFAULT IDLE_TIME KERNEL UNLIMITED NO NO NO

DEFAULT CONNECT_TIME KERNEL UNLIMITED NO NO NO

DEFAULT PRIVATE_SGA KERNEL UNLIMITED NO NO NO

DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 3 NO NO NO

DEFAULT PASSWORD_LIFE_TIME PASSWORD 60 NO NO NO

PROFILE RESOURCE_NAME RESOURCE LIMIT COM INH IMP

--------------- ---------------------------- -------- ---------- --- --- ---

DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED NO NO NO

DEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED NO NO NO

DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL NO NO NO

DEFAULT PASSWORD_LOCK_TIME PASSWORD 1 NO NO NO

DEFAULT PASSWORD_GRACE_TIME PASSWORD 7 NO NO NO

DEFAULT INACTIVE_ACCOUNT_TIME PASSWORD UNLIMITED NO NO NO

17 rows selected.