Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Grant and Revoke Privileges

931974Aug 21 2012 — edited Aug 21 2012
I read the Oracle book with some self-tests and was confused with the Test question:
You issue these commands:
A. grant select on hr.regions to jon;
B. grant all on hr.regions to jon;
C. grant dba to jon;
D. grant select on hr.regions to public;
Which grants could be revoked to prevent JON from seeing the contents of HR.REGIONS?
(Choose all correct answers.)
A. a, b, c, and d
B. a, c, and d
C. b, c, and d
D. c and d
E. a, b, and c

I research the commands and found that for prevent user from seeing the contents I have to revoke everything, so my answer was A.
but in book answers I found this:
A, B, and C. Any of these will prevent the access.

D is wrong because the grants in (a) and (b) will remain in effect. E is wrong because the
grant to PUBLIC in (d) will remain in effect.

Since I newbe in Oracle I tried this test manually and it works only if you revoke everything.

Is it book issue(typo) or I was wrong according to B and C ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 18 2012
Added on Aug 21 2012
10 comments
1,324 views