In our database, most of the users have a role X, and role X grants
select any table.
I want to maintain this privilage for most of the tables, but I do not want some users access some tables in the database.
When I try
revoke all on certain_schema.CERTAIN_TABLE from public
it says 'DONE'.
But it simply does not work, because other users still can select this
And when I try
revoke select on certain_schema.CERTAIN_TABLE from public
ORA-01927: cannot REVOKE privileges you did not grant
How can I prevent other users select