User privilege for getMetaData()

Thread view:

john_yopp@yahoo.com - 02 Jun 2005 23:38 GMT

When using a basic user with only data query and update privileges I
cannot get column data from the DatabaseMetaData object returned from
getMetaData() (on a connection using the JDBC Oracle thin driver).
When I use the schema owner with full privileges, I get the column
data. What privilege is necessary to get column information from
getMetaData?

Reply to this Message

John Currier - 03 Jun 2005 19:36 GMT

I experienced the same problem with meta.getIndexInfo() (even with
approximate set to true) under Oracle, but never for meta.getColumns().
I had to do an ugly hack to work around the resulting ORA-01031
problems.

See if my SchemaSpy (http://schemaspy.sourceforge.net) experiences the
same problems.

John

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...