Tool, Session, Lock hangs

Amin

Member
When I log-in using a READ-ONLY account in Oracle 7.3.4 and choose Tool, Session and choose Cursors, Sql Text or Statistics, appropriate results are displayed. But when I choose Locks tab, the tool HANGS. Is there a solution to this issue without changing the account privileges? Or what privileges should be set to make it work properly?

When I tried with other accounts (that can insert, delete, update rows or create, alter or drop tables and other objects), the tool does not hang.

Please suggest a solution.

Thanks
Amin
 
By the way, similar functionality is working fine with the free version of TOAD when I logged in as a READ-ONLY account. Therefore it is an issue with pl/sql developer.

Amin
 
I'm not sure why it would hang. I can't reproduce it either. If the user does not have access to the dynamic performance view that is used, the result grid shows a "Table or view does not exist" message.

How exactly was the user created and which object/role/system privileges does it have?
 
Back
Top