PL SQL 10.0 user object compareison error

[Lewis]

Hi, I try to use PL SQL 10.0 doing user object comparison. I have two accounts, one is db owner and the other is report user, who only has select privilege for tables and views. I can do the comparison if I log in session with db owner and change the user at the bottom to the report user. However if I log on session as report user I got and error: ora-00942, table or view does not exist. I used to do this with PLSQL 7.0. Something was broken after upgrading to PLSQL 10.0. Can anyone help? Thanks

 

[Marco Kalter]

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).

 

[Lewis]

Hi Marco,

Thanks for your help. I really appreciate it. Here are the last lines of the debug file, where the problem started. Dose it mean I need to give select to this report user? Why didn't I have to do it in PLSQL 7?

Thanks
Lewis

8/19/2014 9:12:00 AM TOracleQuery $05189730 Start Query.Execute
SQL = select text from sys.all_source
where owner = wner
and name = :name
and type = :type
order by line
:OWNER = oracle_rpt
:NAME = TESTREPORT
:TYPE = PACKAGE
8/19/2014 9:12:00 AM TOracleQuery $05189730 End
Result = ORA-00942: table or view does not exist
Duration = 0
8/19/2014 9:12:41 AM NavigationBookmarks.EnableButtons(Rebuild)
8/19/2014 9:12:41 AM NavigationBookmarks: Backward=0, Forward=0

 

[Marco Kalter]

Yes, both version 7.x and 10.0 require select privileges on the sys.all_source view for the user of the target session.

 

[Lewis]

Thanks Marco.