Public Schema
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Public Schema

  1. #1
    Join Date
    Feb 2000
    Posts
    24
    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!
    -Chris

  2. #2
    Join Date
    Nov 1999
    Location
    Elbert, Colorado, USA
    Posts
    81
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width