PROFILE

PROFILE

create  profile  monitoring_profile
limit
COMPOSITE_LIMIT            DEFAULT
SESSIONS_PER_USER          default
CPU_PER_SESSION            default
CPU_PER_CALL               default
LOGICAL_READS_PER_SESSION  default
LOGICAL_READS_PER_CALL     default
IDLE_TIME                  default
CONNECT_TIME               default
PRIVATE_SGA                default
FAILED_LOGIN_ATTEMPTS      default
PASSWORD_LIFE_TIME         UNLIMITED
PASSWORD_REUSE_TIME        UNLIMITED
PASSWORD_REUSE_MAX         UNLIMITED
PASSWORD_VERIFY_FUNCTION   default
PASSWORD_LOCK_TIME         UNLIMITED
PASSWORD_GRACE_TIME        UNLIMITED
;
alter  user  MG profile tbx_profile;

alter   profile DEfault   limit  PASSWORD_LIFE_TIME unlimited;

alter   profile WEB   limit IDLE_TIME unlimited;
alter  profile USER_APPLICATIF  LIMIT  PASSWORD_LOCK_TIME 1;
 alter  profile USER_APPLICATIF  LIMIT  FAILED_LOGIN_ATTEMPTS 10;