aaa

CREATE PROFILE prfl_steward LIMIT
    SESSIONS_PER_USER       1000 --MASSIMO NUMERO DI STEWARD
    CPU_PER_SESSION         DEFAULT
    CPU_PER_CALL            4000 --SECONDS OF CPU
    CONNECT_TIME            5   --MINUTES
    LOGICAL_READS_PER_SESSION   DEFAULT
    LOGICAL_READS_PER_CALL      500 --NUMBER OF BLOCKS
    PRIVATE_SGA         15k
    COMPOSITE_LIMIT         5000000
    FAILED_LOGIN_ATTEMPTS       5
    PASSWORD_LIFE_TIME      365 --DAYS
    PASSWORD_REUSE_TIME     365
    PASSWORD_REUSE_MAX      2
    PASSWORD_VERIFY_FUNCTION        VALIDATE_PASSW
PASSWORD_LOCK_TIME      1/24
    PASSWORD_GRACE_TIME         3;


CREATE PROFILE prfl_amministratore LIMIT
    SESSIONS_PER_USER       75 --MASSIMO NUMERO DI AMMINISTRATORI
    CPU_PER_SESSION         DEFAULT
    CPU_PER_CALL            10000 --SECONDS OF CPU
    CONNECT_TIME            180   --MINUTES
    LOGICAL_READS_PER_SESSION   DEFAULT
    LOGICAL_READS_PER_CALL      2500 --NUMBER OF BLOCKS
    PRIVATE_SGA         15k
    --COMPOSITE_LIMIT           5000000
    FAILED_LOGIN_ATTEMPTS       3
    PASSWORD_LIFE_TIME      15 --DAYS
    PASSWORD_REUSE_TIME     UNLIMITED
    PASSWORD_VERIFY_FUNCTION        VALIDATE_PASSW_AMMINISTRATORI
    PASSWORD_LOCK_TIME      1/24
    PASSWORD_GRACE_TIME         0
/