Synonyms do not show up in User creation script even though option is checked in the Script Options (4310455)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Synonyms do not show up in User creation script even though option is checked in the Script Options
Description

When using the "create script" from the Schema Browser | Users tab, despite checking the "private synonyms" option in script options, the resulting script does NOT contain any synonym creation commands.
Cause

“Private synonyms” checkbox on the “Common” tab means “synonyms for the selected objects”. This dialog is used for getting scripts from all object types in the schema browser. Many object types (tables, sequences, packages, etc) can have synonyms created on them. Some (users, tablespaces, etc) cannot. For the object types that cannot have a synonym created on them, the checkbox is ignored.
Resolution

To get a script for private synonyms owned by a particular user, go to Schema Browser-Synonyms and set the filter for “Private” and “Current Schema Only”. Then select all of the synonyms out of the Schema Browser and get a script for them.

If you have Toad Professional or DBA module, then you could go to Database | Export | Generate Schema Script to extract a script for a user, plus all objects (or objects of a particular type) for a given schema.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title