In your database instance, the user sessions are connected to the database server from the remote machines. You want to achieve the following for these users:
1: The user account must be locked after four unsuccessful login attempts.
2: The user must be prompted to change the password at regular intervals.
3: The user may not have more than three simultaneous sessions.
4: The user session must automatically be logged off if more than 10 minutes elapsed time used.
How would you accomplish the above?
A.by assigning profiles for the users
B.by implementing Fine-Grained Auditing (FGA)
C.by granting a secure application role to the users
D.by implementing the Database Resource Manager plan
可以通过配置 profile 来达到限制上面的目标
SQL> select * from dba_profiles where profile='DEFAULT';
PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED
DEFAULT SESSIONS_PER_USER KERNEL UNLIMITED
DEFAULT CPU_PER_SESSION KERNEL UNLIMITED
DEFAULT CPU_PER_CALL KERNEL UNLIMITED
DEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITED
DEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITED
DEFAULT IDLE_TIME KERNEL UNLIMITED
DEFAULT CONNECT_TIME KERNEL UNLIMITED
DEFAULT PRIVATE_SGA KERNEL UNLIMITED
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10
DEFAULT PASSWORD_LIFE_TIME PASSWORD 180
DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED