Exam Prep Questions

1:You have granted user Haylee the SELECT ANY TABLE privilege WITH ADMIN OPTION. Haylee has granted SELECT ANY TABLE to Blaine and Garrison. After you realize that you granted Haylee the wrong privileges, you revoke her SELECT ANY TABLE privilege. What is the status of Blaine and Garrison?
  • A. Blaine can select from any table, but Garrison cannot.

  • B. Garrison can select from any table, but Blaine cannot.

  • C. Both Blaine and Garrison can select from any table.

  • D. Neither Blaine nor Garrison can SELECT ANY TABLE.

A1: Answer C is correct; both Blaine and Garrison can still select from any table in the database. Answers A and B are incorrect; revoking the SELECT ANY TABLE WITH ADMIN OPTION from Haylee won't revoke the privilege from ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.