grant to public except one user
Hi,
I have created a new user in my database 10g.
I am connecting it thorough an ibm software, its displaying this new users schema objects and all other users public objects.
how can i make this user not access the public objects without revoking public access from those tables.
ex:-new user is user2, old user is user1
user1 created an object as
GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON table1 TO PUBLIC;
now new user user2 is able to see this table, how can i make it unselect.
I do not want to revoke table1 from public as other users are using it, can someone kindly suggest something.