Re: dropping public synonyms?
From: Kirill Richine <kirill_at_cs.ualberta.ca>
Date: 1997/05/06
Message-ID: <5knh1s$igv$1_at_scapa.cs.ualberta.ca>#1/1
Date: 1997/05/06
Message-ID: <5knh1s$igv$1_at_scapa.cs.ualberta.ca>#1/1
[Quoted] Sheilah Scheurich (scheuric_at_sprynet.com) wrote:
: >I was wondering if it is possible to drop public synonyms created by
: >an oracle user. The drop user cascade does not do it. Would I have to
: select 'drop public synonym '||synonym_name||';' from dba_synonyms
: where owner = &owner;
The problem is that the owner of all public synonyms is 'PUBLIC' however I don't want to remove all public synonyms in the database, only the ones created by this user.
So far as I understand, once the public synonym is created, it is intractable to who created it. Is it right?
Thank you.
k&
Received on Tue May 06 1997 - 00:00:00 CEST