OCP-1Z0-052-V8.02-161题
161. In your database instance, the user sessions are connected to the database server from the remotemachines. 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
版权声明：本文为博主原创文章，未经博主允许不得转载。
页:
[1]