[오라클] 프로필 생성 스크립트 (개발자/DBA)

오라클 프로필 생성 스크립트

--개발자용

DROP PRIFLE PROFILE_DEV CASCADE;

CREATE PROFILE PROFILE_DEV LIMIT
	SESSIONS_PER_USER DEFAULT
    CPU_PER_SESSION DEFAULT
    CPU_PER_CALL DEFAULT
    CONNECT_TIME DEFAULT
    IDLE_TIME 10
    LOGICAL_READS_PER_SESSIOKN DEFAULT
    FOGICAL_READS_PER_CALL DEFAULT
    COMPOSIT_LIMIT DEFAULT
    FAILED_LOGIN_ATTEMPTS 5
    INACTIVE_ACCOUNT_TIME DEFAULT
    PASSWORD_LIFE_TIME 90
    PASSWORD_REUSE_TIME 60
    PASSWORD_REUSE MAX 4
    PASSWORD_LOCK_TIME 1
    PASSWORD_GRACE_TIME 7
    PASSWORD_VERIFY_FUNCTION ORA12C_VERIFY_FUNCTION;

 

--DBA용

DROP PRIFLE PROFILE_DEV CASCADE;

CREATE PROFILE PROFILE_DEV LIMIT
	SESSIONS_PER_USER DEFAULT
    CPU_PER_SESSION DEFAULT
    CPU_PER_CALL DEFAULT
    CONNECT_TIME DEFAULT
    IDLE_TIME 10
    LOGICAL_READS_PER_SESSIOKN DEFAULT
    FOGICAL_READS_PER_CALL DEFAULT
    COMPOSIT_LIMIT DEFAULT
    FAILED_LOGIN_ATTEMPTS 6
    INACTIVE_ACCOUNT_TIME DEFAULT
    PASSWORD_LIFE_TIME 90
    PASSWORD_REUSE_TIME 60
    PASSWORD_REUSE MAX 4
    PASSWORD_LOCK_TIME 1
    PASSWORD_GRACE_TIME 7
    PASSWORD_VERIFY_FUNCTION ORA12C_VERIFY_FUNCTION;