How would you accomplish this?

A user establishes a connection to a database instance by using an Oracle Net connection.
You want to ensure the following: 1. The user account must be locked after five
unsuccessful login attempts. 2. Data read per session must be limited for the user. 3- The
user cannot have more than three simultaneous sessions. 4. The user must have a

maximum of 10 minutes session idle time before being logged off automatically. How would
you accomplish this?

A user establishes a connection to a database instance by using an Oracle Net connection.
You want to ensure the following: 1. The user account must be locked after five
unsuccessful login attempts. 2. Data read per session must be limited for the user. 3- The
user cannot have more than three simultaneous sessions. 4. The user must have a

maximum of 10 minutes session idle time before being logged off automatically. How would
you accomplish this?

A.
by granting a secure application role to the user

B.
by implementing Database Resource Manager

C.
by using Oracle Label Security options

D.
by assigning a profile to the user

Show Hint

Leave a Reply 4

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

sudo mucho

sudo mucho

Yes, D.

1. FAILED_LOGIN_ATTEMPTS
Specify the number of consecutive failed attempts to log in to the user account before the account is locked

2. LOGICAL_READS_PER_SESSION
Specify the permitted number of data blocks read in a session, including blocks read from memory and disk

3. SESSIONS_PER_USER
Specify the number of concurrent sessions to which you want to limit the user.

4. IDLE_TIME
Specify the permitted periods of continuous inactive time during a session, expressed in minutes. Long-running queries and other operations are not subject to this limit.

http://docs.oracle.com/database/121/SQLRF/statements_6012.htm#SQLRF01310

Reply

Frank

Frank

Hi,

you were guided by the answers on this site or by the forum

Best Regards,
Frank

[email protected]

Reply

Reply