Examine the statement: CREATE BOLE hr_admin IDENTIFIED USING pac_mgr.hr_admin_rola_ch9ck; Which three are true about the sec_mgr. hr_admin_role_check procedure?
A.
It must use only one security check to validate the user.
B.
It must use the invokcr's rights to enable the role,
C.
It must use the deflner's rights to enable the role.
D.
It can Include one or more security checks to validate the user.
E.
It must contain a SET ROLE statement or a DBMS_SESSION.SET_ROLE call.
F.
It can use only the DBMS_SESSION. SET_ROLE procedure.
G.
Its owner SEC_MGR must be granted the execute any procedure role.
Answer:
CFG
User Votes:
A
50%
B 2 votes
50%
C
50%
D 2 votes
50%
E 2 votes
50%
F 1 votes
50%
G 2 votes
50%
Discussions
0/ 1000
econdeal
9 months, 2 weeks ago
not a. not d. It must include one or more security checks to validate the user. b correct not c.. It must use invoker's rights to enable the role. e correct. It must issue a SET ROLE SQL statement or DBMS_SESSION.SET_ROLE procedure when the user passes the security checks.
seba1494
2 weeks, 4 days ago
D is correct (one or more). In Documentation: "It must include one or more security checks to validate the user. One way to validate users is to use the SYS_CONTEXT SQL function. See Oracle Database SQL Language Reference for more information about SYS_CONTEXT. To find session information for a user, you can use SYS_CONTEXT with an application context."
Want to join our community?
Please log in or signup in order to use this feature
not a. not d. It must include one or more security checks to validate the user.
b correct not c.. It must use invoker's rights to enable the role.
e correct. It must issue a SET ROLE SQL statement or DBMS_SESSION.SET_ROLE procedure when the user passes the security checks.
D is correct (one or more). In Documentation: "It must include one or more security checks to validate the user. One way to validate users is to use the SYS_CONTEXT SQL function. See Oracle Database SQL Language Reference for more information about SYS_CONTEXT. To find session information for a user, you can use SYS_CONTEXT with an application context."