Skip to Main Content
Forums

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!

user having rights to select any table, revoke access from any one table!

misterimranJan 12 2011 — edited Jan 12 2011
Dear All,

My Oracle Database is 11gR1 and Linux is the platform.

I have more then 3000 tables in different schema of my DB. To a number of users i have assigned the grant to "select any table"

Now I have to revoke access of one table, no one other then a dba can select this table. Is there any solution?

Thank you so much.

Regards, Imran
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 9 2011
Added on Jan 12 2011
#general-database-discussions
7 comments
1,411 views