Re: V$SESSION who can access to this view

From: Allan Plesniarski <aplesnia_at_my-deja.com>
Date: Fri, 14 Jan 2000 17:05:40 GMT
Message-ID: <85nl0n$4pv$1@nnrp1.deja.com>

In article <387f3ce9_3_at_news2.prserv.net>, "Nicolas Bronke" <newsgroup_at_trinity.de> wrote:
> Which privileges are necessary to perform a select * from v$session.
>
> I would like to grant this rights someone without DBA-rights
>
> I tried to perform a grant select using the SYSTEM user. But system
does not
> have enough rights.
> I tried to perform a grant select using the SYS user. I got the error
> message that this is not possible!
>
> Does exist a possibility on Oracle 8.0.5?
>
> --
> Regards
> Nicolas Bronke
>
>

V$ views are created by catalog.sql.
One way to find the grants is edit this file in $ORACLE_HOME/rdbms/admin:

create or replace view v_$session as select * from v$session; drop public synonym v$session;
create public synonym v$session for v_$session; grant select on v_$session to select_catalog_role;

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jan 14 2000 - 11:05:40 CST