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 create this role?
A.
as a secure application role
B.
with definer’s rights
C.
with global authentication
D.
with external authentication
Explanation:
https://docs.oracle.com/cd/B28359_01/network.111/b28531/authorization.htm#DBSEG97973