Skip to Content
Former Member
Feb 15, 2010 at 01:19 PM

Synonyms of sequences not shown in Database-studio


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 ?