Synonyms of sequences not shown in Database-studio 7.7.06.09.

[Former Member]

We use two databaseschema's OWNER + USER.

We create the tables and sequences as OWNER.

We grant the tables and sequences as schema-user OWNER to the schema-user USER.

Then as schema-user we create a synonym for every table and sequence which belongs to the schema-user OWNER.

Now when i look in the Database-studio (login as USER) i see in the map tables all the tables from the OWNER-schema.

But i don't see the sequences in the map Sequences.

My question is why ?

[Former Member]

Hello,

Please change the Database Studio preferences:

Window->Preferences->Database Studio->Show only own catalog objects.

Best Regards

Wolfgang

Edited by: Wolfgang Auer on Feb 15, 2010 4:42 PM

[Former Member]

The option "Show only own catalog objects" is active.

But the whole map sequences is empty when i see it from the (login as USER).

[Former Member]

Hello,

you have to deactivate this option.

If "Show only own catalog objects" is active you will not see granted catalog objects.

Best Regards

Wolfgang