How to solve tora issue of "object can not be described"

Question

in tora program when i press f4 to open any table this massage appear "Object TABLE_NAME (DB_USER) cannot be described", please, how to solve.

Answer 1

The permissions are the issue:

• A user account only allows a successful login

• Permissions to view a table is granted by the table owner

Use a SELECT statement of the ALL_OBJECTS data dictionary view to see which tables you have access to:

SELECT * FROM ALL_OBJECTS

Use the DBA_TABLES data dictionary view to see all tables:

SELECT * FROM DBA_TABLES

References

• Managing Security for Oracle Database Users

• The Data Dictionary

• Catalog Views/Data Dictionary Views

• Tables Data Dictionary Views

• Data Dictionary Translation Support

• ALL_OBJECTS

• Syntax for Schema Objects and Parts in SQL Statements

• torasql - knowhow:debugger

• Granting Object Privileges on Behalf of the Object Owner

• ALTER USER

• DBMS_DESCRIBE, 1 of 2

• DBMS_DESCRIBE, 2 of 2