Oracle - sequence of different user problem in schema verify

digdas · **Joined:** Thu Jul 17, 2008 11:48 am **Posts:** 4

Hi,

I am trying to verify the schema (using JBoss Seam) of an oracle database. This works for tables, but not for sequences.

What is the problem:
The sequence (and the tables) are created by the user "DBAMGR"
The verification is done with user "DBAUSR"

The tables and views are granted to the DBAUSR. I can use them with the same login through Sql-Developer.

During verification the sequence is not found.
Digging in hibernate code I find:

Code:

        public String getQuerySequencesString() {
                return "select sequence_name from user_sequences";
        }

Doing the same in SqlDeveloper, no rows returned.

When changing the SQL to select sequence_name from all_sequences it works.

As granted tables are shown, but the sequences not, is this a bug? That the sql has to be modified from user_sequences to all_sequences ?
The latter only shows the sequences the user has privelige on (when I look at the view all_sequences)

Or is there another way to do this?

digdas · **Joined:** Thu Jul 17, 2008 11:48 am **Posts:** 4

See:
http://opensource.atlassian.com/project ... e/HHH-1697

Is to be fixed.

Cameron McKenzie · **Posted:** Sat Jul 19, 2008 9:37 am

Thanks for the update, at the very least!