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?
Login
FAQ
Search
