Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 stackoverflow.com Dec 20 '11 at 5:22

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

1 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.

share|improve this answer

Your Answer

 
discard

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