DROP PROFILE HDS_USER CASCADE;

CREATE PROFILE HDS_USER LIMIT
  SESSIONS_PER_USER 3
  CPU_PER_SESSION DEFAULT
  CPU_PER_CALL DEFAULT
  CONNECT_TIME DEFAULT
  IDLE_TIME 15
  LOGICAL_READS_PER_SESSION DEFAULT
  LOGICAL_READS_PER_CALL DEFAULT
  COMPOSITE_LIMIT DEFAULT
  PRIVATE_SGA DEFAULT
  FAILED_LOGIN_ATTEMPTS 3
  PASSWORD_LIFE_TIME 90
  PASSWORD_REUSE_TIME 25
  PASSWORD_REUSE_MAX 25
  PASSWORD_LOCK_TIME UNLIMITED
  PASSWORD_GRACE_TIME 10
  PASSWORD_VERIFY_FUNCTION HDS_USER_VERIFY;
DROP PROFILE HDS_ADMIN CASCADE;

CREATE PROFILE HDS_ADMIN LIMIT
  SESSIONS_PER_USER UNLIMITED
  CPU_PER_SESSION DEFAULT
  CPU_PER_CALL DEFAULT
  CONNECT_TIME DEFAULT
  IDLE_TIME UNLIMITED
  LOGICAL_READS_PER_SESSION DEFAULT
  LOGICAL_READS_PER_CALL DEFAULT
  COMPOSITE_LIMIT DEFAULT
  PRIVATE_SGA DEFAULT
  FAILED_LOGIN_ATTEMPTS 3
  PASSWORD_LIFE_TIME 1095
  PASSWORD_REUSE_TIME 732
  PASSWORD_REUSE_MAX 25
  PASSWORD_LOCK_TIME 0.0006
  PASSWORD_GRACE_TIME 10
  PASSWORD_VERIFY_FUNCTION HDS_SVCACCT_VERIFY;
DROP PROFILE HDS_DBA CASCADE;

CREATE PROFILE HDS_DBA LIMIT
  SESSIONS_PER_USER 6
  CPU_PER_SESSION DEFAULT
  CPU_PER_CALL DEFAULT
  CONNECT_TIME DEFAULT
  IDLE_TIME 15
  LOGICAL_READS_PER_SESSION DEFAULT
  LOGICAL_READS_PER_CALL DEFAULT
  COMPOSITE_LIMIT DEFAULT
  PRIVATE_SGA DEFAULT
  FAILED_LOGIN_ATTEMPTS 3
  PASSWORD_LIFE_TIME 90
  PASSWORD_REUSE_TIME 732
  PASSWORD_REUSE_MAX 25
  PASSWORD_LOCK_TIME UNLIMITED
  PASSWORD_GRACE_TIME 10
  PASSWORD_VERIFY_FUNCTION HDS_USER_VERIFY;
DROP PROFILE HDS_APP CASCADE;

CREATE PROFILE HDS_APP LIMIT
  SESSIONS_PER_USER UNLIMITED
  CPU_PER_SESSION DEFAULT
  CPU_PER_CALL DEFAULT
  CONNECT_TIME DEFAULT
  IDLE_TIME UNLIMITED
  LOGICAL_READS_PER_SESSION DEFAULT
  LOGICAL_READS_PER_CALL DEFAULT
  COMPOSITE_LIMIT DEFAULT
  PRIVATE_SGA DEFAULT
  FAILED_LOGIN_ATTEMPTS 5
  PASSWORD_LIFE_TIME 1095
  PASSWORD_REUSE_TIME 732
  PASSWORD_REUSE_MAX 25
  PASSWORD_LOCK_TIME 0.0006
  PASSWORD_GRACE_TIME 5
  PASSWORD_VERIFY_FUNCTION HDS_SVCACCT_VERIFY;
DROP PROFILE USER_ACCOUNT CASCADE;

CREATE PROFILE USER_ACCOUNT LIMIT
  SESSIONS_PER_USER 3
  CPU_PER_SESSION UNLIMITED
  CPU_PER_CALL UNLIMITED
  CONNECT_TIME UNLIMITED
  IDLE_TIME 15
  LOGICAL_READS_PER_SESSION UNLIMITED
  LOGICAL_READS_PER_CALL UNLIMITED
  COMPOSITE_LIMIT UNLIMITED
  PRIVATE_SGA UNLIMITED
  FAILED_LOGIN_ATTEMPTS 3
  PASSWORD_LIFE_TIME 90
  PASSWORD_REUSE_TIME 732
  PASSWORD_REUSE_MAX 25
  PASSWORD_LOCK_TIME UNLIMITED
  PASSWORD_GRACE_TIME 10
  PASSWORD_VERIFY_FUNCTION AITC_VERIFY_FUNCTION;
DROP PROFILE HDS_SQA CASCADE;

CREATE PROFILE HDS_SQA LIMIT
  SESSIONS_PER_USER 3
  CPU_PER_SESSION DEFAULT
  CPU_PER_CALL DEFAULT
  CONNECT_TIME DEFAULT
  IDLE_TIME 15
  LOGICAL_READS_PER_SESSION DEFAULT
  LOGICAL_READS_PER_CALL DEFAULT
  COMPOSITE_LIMIT DEFAULT
  PRIVATE_SGA DEFAULT
  FAILED_LOGIN_ATTEMPTS 3
  PASSWORD_LIFE_TIME 90
  PASSWORD_REUSE_TIME 732
  PASSWORD_REUSE_MAX 25
  PASSWORD_LOCK_TIME UNLIMITED
  PASSWORD_GRACE_TIME 10
  PASSWORD_VERIFY_FUNCTION HDS_USER_VERIFY;
DROP PROFILE "DEFAULT" CASCADE;

CREATE PROFILE "DEFAULT" LIMIT
  SESSIONS_PER_USER 3
  CPU_PER_SESSION UNLIMITED
  CPU_PER_CALL UNLIMITED
  CONNECT_TIME UNLIMITED
  IDLE_TIME 15
  LOGICAL_READS_PER_SESSION UNLIMITED
  LOGICAL_READS_PER_CALL UNLIMITED
  COMPOSITE_LIMIT UNLIMITED
  PRIVATE_SGA UNLIMITED
  FAILED_LOGIN_ATTEMPTS 3
  PASSWORD_LIFE_TIME 90
  PASSWORD_REUSE_TIME 732
  PASSWORD_REUSE_MAX 25
  PASSWORD_LOCK_TIME UNLIMITED
  PASSWORD_GRACE_TIME 10
  PASSWORD_VERIFY_FUNCTION AITC_VERIFY_FUNCTION;
DROP PROFILE HDS_USER_HEC CASCADE;

CREATE PROFILE HDS_USER_HEC LIMIT
  SESSIONS_PER_USER 3
  CPU_PER_SESSION DEFAULT
  CPU_PER_CALL 30000
  CONNECT_TIME DEFAULT
  IDLE_TIME 15
  LOGICAL_READS_PER_SESSION DEFAULT
  LOGICAL_READS_PER_CALL DEFAULT
  COMPOSITE_LIMIT DEFAULT
  PRIVATE_SGA DEFAULT
  FAILED_LOGIN_ATTEMPTS 3
  PASSWORD_LIFE_TIME 90
  PASSWORD_REUSE_TIME 732
  PASSWORD_REUSE_MAX 25
  PASSWORD_LOCK_TIME UNLIMITED
  PASSWORD_GRACE_TIME 10
  PASSWORD_VERIFY_FUNCTION HDS_USER_VERIFY;
DROP PROFILE HDS_DEFAULT CASCADE;

CREATE PROFILE HDS_DEFAULT LIMIT
  SESSIONS_PER_USER 3
  CPU_PER_SESSION DEFAULT
  CPU_PER_CALL DEFAULT
  CONNECT_TIME DEFAULT
  IDLE_TIME 15
  LOGICAL_READS_PER_SESSION DEFAULT
  LOGICAL_READS_PER_CALL DEFAULT
  COMPOSITE_LIMIT DEFAULT
  PRIVATE_SGA DEFAULT
  FAILED_LOGIN_ATTEMPTS 3
  PASSWORD_LIFE_TIME 3
  PASSWORD_REUSE_TIME 732
  PASSWORD_REUSE_MAX 25
  PASSWORD_LOCK_TIME UNLIMITED
  PASSWORD_GRACE_TIME 0
  PASSWORD_VERIFY_FUNCTION HDS_USER_VERIFY;
DROP PROFILE SERVICE_ACCOUNT CASCADE;

CREATE PROFILE SERVICE_ACCOUNT LIMIT
  SESSIONS_PER_USER UNLIMITED
  CPU_PER_SESSION UNLIMITED
  CPU_PER_CALL UNLIMITED
  CONNECT_TIME UNLIMITED
  IDLE_TIME UNLIMITED
  LOGICAL_READS_PER_SESSION UNLIMITED
  LOGICAL_READS_PER_CALL UNLIMITED
  COMPOSITE_LIMIT UNLIMITED
  PRIVATE_SGA UNLIMITED
  FAILED_LOGIN_ATTEMPTS 3
  PASSWORD_LIFE_TIME 1095
  PASSWORD_REUSE_TIME 732
  PASSWORD_REUSE_MAX 25
  PASSWORD_LOCK_TIME 0.0006
  PASSWORD_GRACE_TIME 10
  PASSWORD_VERIFY_FUNCTION AITC_VERIFY_FUNCTION;
