nerdexam
Exams1Z0-062Questions#68
Oracle

1Z0-062 · Question #68

1Z0-062 Question #68: Real Exam Question with Answer & Explanation

The correct answer is A: by granting a secure application role to the users. You can design your applications to automatically grant a roleto the user who is trying to log in, provided the user meets criteria that you specify. To do so, you create a secure application role, which is a role that is associated with a PL/SQL procedure (or PL/SQL package that

Question

You are administering a database and you receive a requirement to apply the following restrictions: 1. A connection must be terminated after four unsuccessful login attempts by user. 2. A user should not be able to create more than four simultaneous sessions. 3. User session must be terminated after 15 minutes of inactivity. 4. Users must be prompted to change their passwords every 15 days. How would you accomplish these requirements?

Options

  • Aby granting a secure application role to the users
  • Bby creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT
  • CBy creating and assigning a profile to the users and setting the
  • DBy Implementing Fine-Grained Auditing (FGA) and setting the
  • EBy implementing the database resource Manager plan and setting the

Explanation

You can design your applications to automatically grant a roleto the user who is trying to log in, provided the user meets criteria that you specify. To do so, you create a secure application role, which is a role that is associated with a PL/SQL procedure (or PL/SQL package that contains multiple procedures). The procedure validates the user: if the user fails the validation, then the user cannot log in. If the user passes the validation, then the procedure grants the user a role so that he or she can use the application. The user has this role only as long as he orshe is logged in to the application. When the user logs out, the role is revoked.

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice