Sessions - Cursors/SQL Text : ORA-00942 Error

[geraldwinslow]

Sirs,

I'm sure there's a simple solution to this -

When logged in as a 'regular' user and I bring up the Sessions window and click on my session, in the tabbed sections below, I get this:

ORA-00942: table or view does not exist

When I connect as a DBA and do that again, I see actual data. So, I suppose that my 'regular' account doesn't have a privilege or role that I need.

Any ideas?

Thanks!
Gerald

 

[Christo Kutrovsky]

connect as your dba account

open a command window and type

grant dba to ;



if you are ONLY interested in sessions, try (from your dba account):

grant select on sys.v_$session to ;

Good luck.

 

[geraldwinslow]

OK, well, I did end up doing just that, plus granting on v_$ to the regular account. But, I thought there might be a more streamlined way of doing that.

And the PLSQL Dev. help file was no help in this situation, though it did mention that the user should have EXECUTE on dbms_system, which they did already (it didn't solve the problem).

Perhaps I should just create a role for this set of privs.

Thanks for your help!
Gerald