Re: How to tell What PUBLIC Synonym One Created?

Den wrote:

> After a public synonym is created, its owner become PUBLIC in the
> all_objects data dict and I cannot find any other hints related to who is
> the one issued the CREATE PUBLIC SYNONYM command.
>
> Is there any way to identify which public synonym was created by me?

Not from the data dictionary. You can audit after the fact my reviewing the logs, as suggested, or by creating an AFTER DDL trigger that audits the action.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)