unable to revoke "select any table" system priv
I created a new user and unable to revoke select any table permissions. It appears that any new oracle user i create has the select any table permissions. I want to only alow this new user to select from 5 tables and not others. It seems as though there is a global setting on the database to allow select from any table. I can't change that if thats the case but i would like to create this restricted user.
How can I modify permissions on my new oracle user to not allow select any table?
Any help would be appreciated