Grant to one; then revoke from all: does it work in Oracle SQL?

Question

Consider the following:

1. grant select on books to frank.
2. revoke select on books from public.

At the end of executing the above SQL script, will frank have 'select' access to the 'books' table?

Answer 1

Yes, frank will be able to perform a select on books. Basically Oracle will use the most permissive privilege, which is the one allowing selection.

Reference: Documentation (under roles).

---

Note that this is different from you granting privileges with admin option to UserB, who in turn grants privileges to UserC. In this case revoking privileges from UserB would automatically "cascade" revoke them from UserC.