Re: Is v$session available to SYS only?

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 5 Apr 2005 16:46:21 -0700
Message-ID: <1112744781.752781.243020@f14g2000cwb.googlegroups.com>

dd wrote:
> 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.

v$session is actually a synonym for v_$session view. You don't grant permissions on synonyms but objects that they represent.

SELECT on v_$session view is by default ONLY granted to sys and system either directly or via select_catalog_role or dba role.

Regards
/Rauf Received on Tue Apr 05 2005 - 18:46:21 CDT