Re: Is v$session available to SYS only?

From: Dave <x_at_x.com>
Date: Tue, 05 Apr 2005 23:32:12 GMT
Message-ID: <0eF4e.4774$G8.1833@text.news.blueyonder.co.uk>

"dd" <dd_at_dd.com> wrote in message news:42531c92$1_2_at_rain.i-cable.com...
> Is this statement only for SYS (oracle 9i):
>
> select * from v$session;
>
> The SQL Reference doesnt mention this restriction so I just want to double
> confirm this.
>
>

if you have permission to access it you can see it (i.e granted select on it) Received on Tue Apr 05 2005 - 18:32:12 CDT

This message: [ Message body ]
Next message: asktom: "Connecting Oracle thru JDBC"
Previous message: dd: "Is v$session available to SYS only?"
In reply to: dd: "Is v$session available to SYS only?"
Next in thread: asktom: "Re: Is v$session available to SYS only?"
Reply: asktom: "Re: Is v$session available to SYS only?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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