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.
Printable View
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.
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
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'.