OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » v$session view

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

v$session view [message #59397]

Mon, 17 November 2003 03:17

James Briar
Messages: 72
Registered: January 2002
Location: Morden (South London)

Member

What do i have to do to allow another user to be able to use the v$session view (the user only wants access to this view).
(Oracle 8i on a Sun Solaris 8 unix system).
Thanks.

Report message to a moderator

Re: v$session view [message #59399 is a reply to message #59397]

Mon, 17 November 2003 03:31

Maaher
Messages: 7065
Registered: December 2001

Senior Member

The Select privilege on V_$SESSION ( a SYS view ) is by default included in the SELECT_CATALOG_ROLE which is included in the DBA, EXP_FULL_DATABASE and IMP_FULL_DATABASE roles. But there's the public synonym v$session for sys.v_$session, so users won't need to access v_$session directly.

What you need to do is grant the select on v_$session directly to the user or via a role. Connect as sys and issue the grant:

SQL> GRANT SELECT ON v_$session TO your_user;

MHE

Report message to a moderator

Re: v$session view [message #59402 is a reply to message #59399]

Mon, 17 November 2003 05:48

James Briar
Messages: 72
Registered: January 2002
Location: Morden (South London)

Member

Thanks very much for your reply Maaher. The grant worked ok and the other user can now use v$session.

Report message to a moderator

Previous Topic:	Import from 8i to 9i - ORA-00600
Next Topic:	temporary tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 20 03:46:46 CST 2025