Re: Creaste a view based on v_$session

All V$ views are owned by SYS. But you can't grant SELECT privileges on a V$ view to an individual user. Instead, you have to sign on as SYS and grant SELECT on the V_$ view. That's what Sybrand meant by *direct* priv. What I would suggest doing is granting SELECT on the V_$ to the user, but in the SQL statement, use V$ instead.

HTH,
Brian

Brian Tkatch wrote:
>
> On Tue, 19 Sep 2000 18:43:54 +0200, "Sybrand Bakker"
> <postbus_at_sybrandb.demon.nl> wrote:
>
> >Sure, *direct* select privilege on the view.
>
> What does that mean? Which right am I missing?
>
> Brian
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================