Revvoking not possible
I created a user whcih I gave rights to create any objects. He is not allowed to do a select on another schema. when I try to do a select on table A in another schema I get
ora-00942:table or view does not exist.
That is the way it should be.
When I try a select on table B in the same schema as table A it will give me all data. I never granted him any permission on that table.
How come he can still do a select on that table?
How can I prevent him from reading the data from tables in another schema while not
Last edited by gandolf989; 07-10-2014 at 04:11 PM.
Click Here to Expand Forum to Full Width