User privilege for getMetaData()  
Author Message
john_yopp





PostPosted: 2005-6-3 6:39:00 Top

java-programmer, User privilege for getMetaData() 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?

 
John Currier





PostPosted: 2005-6-4 2:37:00 Top

java-programmer >> User privilege for getMetaData() 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