How would you accomplish these requirements?

You are administering a database and you receive a requirement to apply the following
restrictions: 1. A connection must be terminated after four unsuccessful login attempts by
user. 2. A user should not be able to create more than four simultaneous sessions. 3. User

session must be terminated after 15 minutes of inactivity. 4. Users must be prompted to
change their passwords every 15 days. How would you accomplish these requirements?

You are administering a database and you receive a requirement to apply the following
restrictions: 1. A connection must be terminated after four unsuccessful login attempts by
user. 2. A user should not be able to create more than four simultaneous sessions. 3. User

session must be terminated after 15 minutes of inactivity. 4. Users must be prompted to
change their passwords every 15 days. How would you accomplish these requirements?

A.
By implementing the database resource Manager plan and setting the
SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.

B.
By Implementing Fine-Grained Auditing (FGA) and setting the
REMOTE_LOGIN_PASSWORD_FILE parameter to NONE.

C.
By creating and assigning a profile to the users and setting the
SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4

D.
by granting a secure application role to the users

E.
by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT
parameter to FALSE



Leave a Reply 1

Your email address will not be published. Required fields are marked *