DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: public synonyms

  1. #1
    Join Date
    Mar 2001
    Posts
    65
    can i safetly delete the public synonyms created on sys and
    system tables and views to avoid just about any user to have select rights on them?

    as i see in all views on data dictionary have by default
    public synonyms created.


  2. #2
    Join Date
    Oct 2000
    Location
    Halifax, Nova Scotia
    Posts
    197
    Users can only use these public synonyms if they have read access to the underlying tables so my suggestion would be no don't drop the public synonyms

    These were created by Oracle for a reason
    Don't be afraid to try something new. Amateurs built the Ark, professionals built the Titanic

  3. #3
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    DO NOT PLAY AROUND IN THE SYSTEM TABLESPACE AND DO NOT DELETE/ ALTER ANY OBJECTS OWNED BY SYS.
    What is the harm in users seeing DD views ? The scope of views they (ordinary user) can see are limited.
    Users can only see the V$ views if they have been granted 'Select any table' privilege or 'Select_Catalogue_Role'.

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