Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 CERTAIN_TABLE.

And when I try revoke select on certain_schema.CERTAIN_TABLE from public

it throws:

ORA-01927: cannot REVOKE privileges you did not grant

How can I prevent other users select CERTAIN_TABLE ?

share|improve this question
1  
You need to re-think your security model. SELECT ANY TABLE means exactly that. –  Phil Oct 25 '13 at 11:53

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.