OCP-1Z0-052-V8.02-161题

我是007

　　161. 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.PASSWORD_LOCK_TIME
　　2: The user must be prompted to change the password at regular intervals.PASSWORD_LIFE_TIME
　　3: The user may not have more than three simultaneous sessions.SESSIONS_PER_USER
　　4: The user session must automatically be logged off if more than 10 minutes elapsed time used.CONNECT_TIME
　　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
　　Answer: A
　　答案解析：
　　参考：http://blog.iyunv.com/rlhua/article/details/12277557
　　
　　创建一个概要文件，来实施口令安全。
　　default概要文件的配置。
sys@TEST0924> select * from dba_profiles where profile='DEFAULT';PROFILE RESOURCE_NAME RESOURCE LIMIT------------------------------ -------------------------------- -------- ----------------------------------------DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITEDDEFAULT SESSIONS_PER_USER KERNEL UNLIMITEDDEFAULT CPU_PER_SESSION KERNEL UNLIMITEDDEFAULT CPU_PER_CALL KERNEL UNLIMITEDDEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITEDDEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITEDDEFAULT IDLE_TIME KERNEL UNLIMITEDDEFAULT CONNECT_TIME KERNEL UNLIMITEDDEFAULT PRIVATE_SGA KERNEL UNLIMITEDDEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10DEFAULT PASSWORD_LIFE_TIME PASSWORD 180DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITEDDEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITEDDEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULLDEFAULT PASSWORD_LOCK_TIME PASSWORD 1DEFAULT PASSWORD_GRACE_TIME PASSWORD 7　　16 rows selected.
http://onexin.iyunv.com/source/plugin/onexin_bigdata/file:///C:/Users/Administrator/AppData/Local/Temp/Wiz/ae16719c-866c-4983-865b-68a5b2a51a34_128_files/11954309.png
http://onexin.iyunv.com/source/plugin/onexin_bigdata/file:///C:/Users/Administrator/AppData/Local/Temp/Wiz/ae16719c-866c-4983-865b-68a5b2a51a34_128_files/11975307.png
         版权声明：本文为博主原创文章，未经博主允许不得转载。