Create or alter profile in Oracle database.
Create a Profile for users in Oracle Database
CREATE PROFILE "APP_PROFILE" LIMIT COMPOSITE_LIMIT UNLIMITED SESSIONS_PER_USER UNLIMITED CPU_PER_SESSION UNLIMITED CPU_PER_CALL UNLIMITED LOGICAL_READS_PER_SESSION UNLIMITED LOGICAL_READS_PER_CALL UNLIMITED IDLE_TIME 90 CONNECT_TIME UNLIMITED PRIVATE_SGA UNLIMITED FAILED_LOGIN_ATTEMPTS 10 PASSWORD_LIFE_TIME 180 PASSWORD_REUSE_TIME UNLIMITED PASSWORD_REUSE_MAX UNLIMITED PASSWORD_VERIFY_FUNCTION NULL PASSWORD_LOCK_TIME UNLIMITED PASSWORD_GRACE_TIME UNLIMITED;
Alter profile for Oracle User
ALTER PROFILE APP_PROFILE LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Note: Meaning for all the profile parameters as below:
*SESSION_PER_USER – No. of allowed concurrent sessions for a user. *CPU_PER_SESSION – CPU time limit for a session, expressed in hundredth of seconds. *CPU_PER_CALL – Specify the CPU time limit for a call (a parse, execute, or fetch), expressed in hundredths of seconds. *CONNECT_TIME – Specify the total elapsed time limit for a session, expressed in minutes. *IDLE_TIME – Specify the permitted periods of continuous inactive time during a session, expressed in minutes. *LOGICAL_READS_PER_SESSION – Specify the permitted number of data blocks read in a session, including blocks read from memory and disk. *LOGICAL_READS_PER_CALL –permitted number of data blocks read for a call to process a SQL statement (a parse, execute, or fetch). *PRIVATE_SGA – SGA a session can allocate in the shared pool of the system global area (SGA), expressed in bytes. *FAILED_LOGIN_ATTEMPTS – No. of failed attempts to log in to the user account before the account is locked *PASSWORD_LIFE_TIME : No. of days the account will be open. after that it will expiry. *PASSWORD_REUSE_TIME : number of days before which a password cannot be reused. *PASSWORD_REUSE_MAX : number of days before which a password can be reused. *PASSWORD_LOCK_TIME :Number of days the user account remains locked after failed login. *PASSWORD_GRACE_TIME :Number of grace days for user to change password. *PASSWORD_VERIFY_FUNCTION :PL/SQL that can be used for password verification.