Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How perform select * from V$SESSION in Oracle procedure !!

Re: How perform select * from V$SESSION in Oracle procedure !!

From: Linh Bui <linh_at_data-sci.com>
Date: Thu, 8 Jul 1999 16:12:07 -0400
Message-ID: <7m30v8$shh$1@autumn.news.rcn.net>


Repost due to connection lost.

In general, a stored code is executed under the privilege of the its owner. Thus, you need to grant the owner of the procedure being executed the privilege to access sys.v_$session.

Linh
Freelance Contractor Received on Thu Jul 08 1999 - 15:12:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US