DATABASE PROFILES
- Get link
- X
- Other Apps
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.
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.
- Get link
- X
- Other Apps
Comments
Post a Comment