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!

Question regarding grant & revoke select on tables- Oracle 11g.

885068Nov 30 2015 — edited Dec 3 2015

Hello-

I have the following scenario & was hoping experts on this site to give me the best practices option on the following:

A)Schema 1 has grant select on all tables(2000) of schema 2.

B) Then tables of schema 2 have been dropped & recreated with ETL process.

I noticed after the drop & recreate ; schema 1 still had grant select on tables with naming convention of BIN$ which makes sense because they(tables) have been dropped.

My question: What is the best way to clean up the grant privileges of schema 1. I did perform revoke select from user(2000 tables); But I was wondering if there is an efficient way.

I do understand that I will have to run the grant selct on all tables again.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 31 2015

Added on Nov 30 2015

#11g, #general-database-discussions

13 comments

3,644 views