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!