PROFILE 생성과 관리

실습 : profile 이용 user를 제한한다. 

 

SQL> conn / as sysdba;

 

SQL> desc dba_profiles;

 

 

SQL> select distinct profile from dba_profiles;

 

 

SQL> select username,profile from dba_users;

 

SQL> !vi /home/oracle/product/10g/dbs/inittestdb.ora
resource_limit=true <- 파라미터 추가

 

SQL> alter system set resource_limit=true;

System altered.

 

SQL> create profile test_profile limit
  2  sessions_per_user 2 <- Session을 2개까지만 허용
  3  idle_time 5; <- 5분간 입력이 없으면 접속종료

Profile created.

 

select * from dba_profiles
where profile='TEST_PROFILE'
order by resource_type

 

SQL> alter user scoot profile test_profile;

 

SQL> alter profile test_profile limit

failed_logi_attempts 3 <- 잘못된 login이 3번이면 lock 됨

password_life_time 30; <- passwd는 30일마다 바꿔야함

 

SQL> select username,profile from dba_users where username = 'SCOTT';

( SCOTT 에게 어떤 profile 있는지 조회 )

 

SQL> drop profile test_profile cascade; ( 삭제 )

Profile dropped.