Re: Process Id

Daniel Morgan <damorgan_at_x.washington.edu> wrote :
>
> GRANT SELECT ON v_$session TO <schema_name>;

If it comes down to that, I would rather grant select on v$mystat - to get your SID do a
SELECT sid FROM v$mystat WHERE rownum = 1

And this also gives the session access to all its own stats - not much harm, security wise, in that.

--
Billy