Description
wrathburn created an issue — 5th March 2012, 21:53:13:
I am working on a project where I want to validate an Oracle schema via another Oracle user account. Everything works except for validating sequences. The query in the Oracle8iDialect for getting the sequences is "select sequence_name from user_sequences" which only works if you are logged in as that schema owner. Would it be better to use something like
"select sequence_name from sys.all_sequences where owner = upper('" + Environment.Properties["default_schema"] + "'". This would require a default_schema specified in the configuration but would return a correct set of sequences as long as the asking schema as SELECT permissions granted to the schema.The fix for my project is I use a custom Oracle Dialect which can be seen in the attached file.