I'm trying to link an access front-end to my oracle database. I've got the user Roles all ironed out. My only concern is that once a user has the 'create session' priviledge, they can 'see' all the synoyms stored in PUBLIC.
1) How can I prevent that from happening.
2) What effect will changing the PUBLIC grantee on those synonyms have on the database.
Thanks for any help!
You can't prevent this behavior. The whole point of PUBLIC is that you have certain things that you want every user to have access to by default.
If you don't want users to see these synonyms, then you must drop them. This will force code/users to fully qualify object names in code/queries or create their own synonyms.