Synonyms Question
create pubic synonym and grants for all these SYSADM objects so that a few other users can access these objects. like to remove all these public synonyms for SYSADM objects and then redo them. We have created a script that will drop these public synonyms for SYSADM tables and views, and run it under SYSADM user and it appears to be dropping them. But when I do the following query in database in dba_synonyms it is still showing
select count(*) from dba_synonyms
where owner = 'PUBLIC'
and table_owner = 'SYSADM';
4575
Any Idea please ?
select count(*) from dba_synonyms
where owner = 'PUBLIC'
and table_owner = 'SYSADM';
4575
Any Idea please ?
0