nerdexam
Oracle

1Z0-062 · Question #272

You want to create a role that: - is protected from unauthorized usage - does not use a password embedded in the application source code or stored in a table - is enabled for a user based on…

The correct answer is A. as a secure application role. https://docs.oracle.com/cd/B28359_01/network.111/b28531/authorization.htm#DBSEG979

Administering User Security

Question

You want to create a role that:

  • is protected from unauthorized usage
  • does not use a password embedded in the application source code or

stored in a table

  • is enabled for a user based on security policies defined in a PL/SQL

package How would you createthis role?

Options

  • Aas a secure application role
  • Bwith definer's rights
  • Cwith global authentication
  • Dwith external authentication

How the community answered

(64 responses)
  • A
    92% (59)
  • B
    2% (1)
  • C
    2% (1)
  • D
    5% (3)

Explanation

https://docs.oracle.com/cd/B28359_01/network.111/b28531/authorization.htm#DBSEG979

Topics

#Oracle roles#Secure application roles#Security policies#PL/SQL

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice