DATABASE PROFILES

create profile p1 limit sessions_per_user 2 failed_login_attempts 3;


Statement processed.

0.03 seconds
select * from dba_profiles

PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT
DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED
DEFAULT SESSIONS_PER_USER KERNEL UNLIMITED
DEFAULT CPU_PER_SESSION KERNEL UNLIMITED
DEFAULT CPU_PER_CALL KERNEL UNLIMITED
DEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITED
DEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITED
DEFAULT IDLE_TIME KERNEL UNLIMITED
DEFAULT CONNECT_TIME KERNEL UNLIMITED
DEFAULT PRIVATE_SGA KERNEL UNLIMITED
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10
select username , profile from dba_users

alter user scott profile p1


User altered.

0.01 seconds
select username , profile from dba_users where profile='P1'

USERNAME PROFILE
SCOTT P1

select username , machine , terminal from v$session session where username='SCOTT'


select username , account_status from dba_users where profile='P1'

USERNAME ACCOUNT_STATUS
SCOTT OPEN


select username , machine , terminal from v$session session where username='SCOTT'


 select username , machine , terminal from v$session where username='SCOTT'


SQL> conn scott/tig
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn scott/tigERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn scott/tiger
ERROR:
ORA-28000: the account is locked
select username , account_status from dba_users where profile='P1'


USERNAME ACCOUNT_STATUS
SCOTT LOCKED(TIMED)


alter user scott account unlock;


User altered.


0.01 seconds


select username , account_status from dba_users where profile='P1'


USERNAME ACCOUNT_STATUS
SCOTT OPEN


alter profile p1 limit password_lock_time 1/1440;



select * from dba_profiles where profile ='P1';

P1 PASSWORD_LOCK_TIME PASSWORD 0.0006




SQL> conn scott/tig
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn scott/tig
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn scott/tig
ERROR:
ORA-28000: the account is locked



SQL> conn scott/tiger
ERROR:
ORA-28000: the account is locked


SQL> conn scott/tiger
ERROR:
ORA-28000: the account is locked


SQL> conn scott/tiger
ERROR:
ORA-28000: the account is locked

after 1 min 
SQL> conn scott/tiger
Connected.