#615 error getting the index-view

open
nobody
5
2014-12-11
2008-02-22
Anonymous
No

witzh any version up to now i cant display the index of any table.

I get:
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab

Stack Trace:
java.sql.SQLException: ORA-01031: insufficient privileges

at oracle.jdbc.driver.DatabaseError.throwSqlException\(DatabaseError.java:112\)
at oracle.jdbc.driver.T4CTTIoer.processError\(T4CTTIoer.java:331\)
at oracle.jdbc.driver.T4CTTIoer.processError\(T4CTTIoer.java:288\)
at oracle.jdbc.driver.T4C8Oall.receive\(T4C8Oall.java:745\)
at oracle.jdbc.driver.T4CStatement.doOall8\(T4CStatement.java:207\)
at oracle.jdbc.driver.T4CStatement.executeForRows\(T4CStatement.java:957\)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout\(OracleStatement.java:1170\)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal\(OracleStatement.java:1623\)
at oracle.jdbc.driver.OracleStatement.executeUpdate\(OracleStatement.java:1588\)
at oracle.jdbc.OracleDatabaseMetaData.getIndexInfo\(OracleDatabaseMetaData.java:3486\)
at net.sourceforge.squirrel\_sql.fw.sql.SQLDatabaseMetaData.getIndexInfo\(SQLDatabaseMetaData.java:1515\)
at net.sourceforge.squirrel\_sql.client.session.mainpanel.objecttree.tabs.table.IndexesTab.createDataSet\(IndexesTab.java:76\)
at net.sourceforge.squirrel\_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run\(BaseDataSetTab.java:123\)
at net.sourceforge.squirrel\_sql.fw.util.TaskExecuter.run\(TaskExecuter.java:82\)
at java.lang.Thread.run\(Unknown Source\)

--> Why do I need more privileges than I have to read the given indizes of any table I have access to?

With the Oracle-SQL-Developer-Tool I can see any index and its function behind (if set) of any table in the database I have granted access.

Sorry for my bad english.
Peter

Discussion


Log in to post a comment.