Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

migrated from Dec 20 '11 at 5:22

This question came from our site for professional and enthusiast programmers.

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.