Code Assistant permissions

[plsqldev]

Hello

Getting error when select column in the select list. what permission do i need?

example:
i logged into the database as schema owner . say scott/scott
when write select statement..

SELECT EMP.

i get an error saying table/view does not exist.. Why am i getting this error .

I am the owner of the schema i own all the tables. i should able to list the columns.

can you please explain why and what permission do i require?

Thanks
pldev.

 

[Marco Kalter]

You will need select privileges on the sys.all_* views, which are granted to public by default.

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

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

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).

 

[plsqldev]

Dba's are not granting select permission on any sys.all_* views based on the security policy by Oracle . see the policy violation alert from OEM.

Category :Security
Description :Ensures Select privilege is never granted to any DBA .

but we have access to user_tab_columns.
thanks
pldev