sql windows ora-6550 ora-942

[avishay]

in the sql window i'm try to see columns of
tables -
"select * from hearot t
where t."

and then i see the message -"ora-6550 ora-942 table or view does not exists"

i changed the "use DBA views if available"
on and off - it did not help.

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the debug parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debug

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.

 

[avishay]

PL/SQL Developer 5.1.2.687 02.7858 - 20 user license
C:\Program Files\PLSQL Developer\PLSQLDev.exe

15/03/2005 13:52:54 Application started
15/03/2005 13:53:01 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\HOME0
OracleHomeDir: \\orant2\orawinfs\OraClient_2000\orawin95
Found: oci.dll
Found: ORA73.DLL
Found: ORA803.DLL
Found: ORA804.DLL
Found: ORA805.DLL
Using: \\orant2\orawinfs\OraClient_2000\orawin95\bin\oci.dll
15/03/2005 13:53:18 Create TCommandForm
15/03/2005 13:53:31 InterpretLine starts: desc cs_bakashot
15/03/2005 13:53:35 InterpretLine ends
15/03/2005 13:53:38 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\HOME0
OracleHomeDir: \\orant2\orawinfs\OraClient_2000\orawin95
Found: oci.dll
Found: ORA73.DLL
Found: ORA803.DLL
Found: ORA804.DLL
Found: ORA805.DLL
Using: \\orant2\orawinfs\OraClient_2000\orawin95\bin\oci.dll
15/03/2005 13:53:44 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\HOME0
OracleHomeDir: \\orant2\orawinfs\OraClient_2000\orawin95
Found: oci.dll
Found: ORA73.DLL
Found: ORA803.DLL
Found: ORA804.DLL
Found: ORA805.DLL
Using: \\orant2\orawinfs\OraClient_2000\orawin95\bin\oci.dll
15/03/2005 13:53:57 InterpretLine starts: desc cs_bakashot
15/03/2005 13:53:58 InterpretLine ends
15/03/2005 13:56:18 InterpretLine starts: select * from kl_kpr t where t.
15/03/2005 13:56:18 InterpretLine ends
15/03/2005 13:56:20 InterpretLine starts: .
15/03/2005 13:56:20 InterpretLine ends
15/03/2005 13:56:21 InterpretLine starts: .
15/03/2005 13:56:21 InterpretLine ends
15/03/2005 13:56:21 InterpretLine starts:
15/03/2005 13:56:22 InterpretLine starts:

 

[avishay]

i found what is the needed privileges for the operation.

grant select on all_tab_columns to pl_sql_developer_role;
grant select on all_col_comments to pl_sql_developer_role;
grant select on ALL_OBJECTS to pl_sql_developer_role;
grant select on ALL_SYNONYMS to pl_sql_developer_role;
grant select on ALL_SYNONYMS to pl_sql_developer_role;
grant select on all_users to pl_sql_developer_role;
grant select on all_constraints to pl_sql_developer_role;

then i granted the role to users that want to connect to the tool.

thank alot
you can close the topic