1z0-116 question 78 discussion

View all Oracle Database Security Administration Exam here
back to oracle forum

Question 78

A DBA user created and configured this secure application role:

Why does the error occur?

  • A. User psmith Is connecting outside of the SYSDATE specified.
  • B. The set hole hr_admin stuternent must be executed with the dbms. session. set_role procedure.
  • C. user psmith is connecting remotely.
  • D. The HR_ADMIN role must be granted to user PSMITH.
  • E. The HR.ROLE_CHECK procedure must be created with the AUTHID CURRENT_USERR clause.
  • F. The HR.ROLE_CHECK procedure must be created without the AUTHID clause.
Answer:

D


User Votes:
A
50%
B
50%
C 2 votes
50%
D 1 votes
50%
E 1 votes
50%
F
50%
Discussions
0 / 1000
econdeal
8 months, 2 weeks ago

rpta C. i test that , only remoty is the error.

econdeal
8 months, 1 week ago

se corrige la respuesta es e The HR.ROLE_CHECK procedure must be created with the AUTHID CURRENT_USERR clausere