11g database:
--------------------
I want to grant a user select privilege on all tables except few tables. I thought of granting "Select any table", but this doesn't work as few tables he shouldn't access.
2nd way is to go schema wise and grant select privileges...one by one using script. But this is time consuming as we have huge number of tables.
Is there any other way using which we can accomplish this easily.