Evaluate the statements issued by the DBA in the given sequence if OE and SCOTT are the users and th...........

Computer GK ( CHSL) DBMS

Evaluate the statements issued by the DBA in the given sequence if OE and SCOTT are the users and the ORDERS table is owned by OE.

CREATE ROLE r1;

GRANT SELECT, INSERT ON oe. orders TO r1;

GRANT r1 TO scott;

GRANT SELECT ON oe. orders TO scott;

REVOKE SELECT ON oe.orders FROM scott;

What would be the outcome after executing the statements?

The REVOKE statement would give an error because the SELECT privilege has been granted to the role R1

The REVOKE statement would remove the SELECT privilege from SCOTT as well as from the role R1

SCOTT would be able to query the OE.ORDERS table

SCOTT would not be able to query the OE.ORDERS table

To perform operations on objects, the REVOKE statement is used to revoke rights from a single user or role, or from all users.

Submit Error