Re: letting users see v$process table

Gary

I think you'll find that v$process is itself a synonym of sys.v_$process. If you connect as SYS and grant select on V$process to your use s(he) should be able to read the data successfully without needing the SYSYEM password.

Hope this helps

Regards

John Roberts

Gary Assa <gsa_at_panix.com> wrote in article <6545mm$mbk_at_panix.com>...
> I have a script that list some information on processes that I want an
 admin
> user who is collecting data to find out what processes are dead,
 inactive,
> etc.
>
Received on Sat Nov 22 1997 - 00:00:00 CET