Database Administration (MOSC)

MOSC Banner

Password profile for system accounts

edited Apr 16, 2021 1:58PM in Database Administration (MOSC) 4 commentsAnswered ✓

Hi team,

I have received request to create password profile for our system accounts (sys, system). Database is version 12.1 and internal auditors wish to place in these values for password profile:

CREATE PROFILE SYS_PROFILE LIMIT

 SESSIONS_PER_USER UNLIMITED

 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 5

 PASSWORD_LIFE_TIME 97

 PASSWORD_REUSE_TIME 5

 PASSWORD_REUSE_MAX 5

 PASSWORD_LOCK_TIME 0.0206

 PASSWORD_GRACE_TIME 1

 PASSWORD_VERIFY_FUNCTION ORA12C_STRONG_VERIFY_SYS;


My only concern is IDLE_TIME = 15 minutes for SYS user. Does this setup will affect database in any way? Just to mention database is a part of EBS.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center