Database user SCOTT requires the privilege to select from all tables and you decide to...

Oracle 1z0-116 Question Answer

Database user SCOTT requires the privilege to select from all tables and you decide to configure this using a global role.

You have not yet configured the database with Enterprise User Security.

You plan to perform these steps:

1. create role GLOBAI._ROI.E identified globally;

2. grant select any table to GLODAL_COLE;

3. grant GLOBAL_ROLE to SCOTT;

What is the result?

All statements succeed even without Enterprise User Security configuration, but the role is not effective.

The third statement falls because global roles can be granted only by using a central authority.

The second statement falls because granting a global role can be completed only by using a central authority.

The first statement falls because the database Is not set up with Enterprise User Security.

1z0-116 PDF/Engine

Get 65% Discount on All Products, Use Coupon: "ac4s65"