📝 Question
#1685
OE and SCOTT are the users in the database. The ORDERS table is owned by OE. Evaluate the statements issued by the DBA in the following sequence: 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;
✓
Correct Answer
C. The REVOKE statement would remove the SELECT privilege from SCOTT as well as from the role R1
💡
Explanation
The REVOKE statement is used to remove privileges from a specific user or role, or from all users, to perform actions on database objects.
⌨️ Press
A
B
C
D
to select