Re: Deleting synonyms

> How can I delete all synonyms owned by one particular user?

like this?

declare
  v_schema varchar2(30) := 'your_user_name'; begin
  for r in (select synonym_name from user_synonyms) loop     dbms_output.put_line(r.synonym_name);     execute immediate 'drop synonym ' || v_schema || '.' || r.synonym_name;   end loop;
end;
/

Make sure you change your_user_name to something useful

Hope this helped

Rene

-- 
Latest article on my HP (as of 14.07.2002):
  Transforming each character in a string with perl
  http://www.adp-gmbh.ch/perl/each_char.html