Path: text.usenetserver.com!out02b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!post01.iad01!not-for-mail
Date: Tue, 12 Dec 2006 09:18:33 -0800
From: DA Morgan <damorgan@psoug.org>
Organization: Puget Sound Oracle Users Group
User-Agent: Thunderbird 1.5.0.8 (Windows/20061025)
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: current users enquiry
References: <1165916955.301010.285640@n67g2000cwd.googlegroups.com>   <1165926530.064837.309420@n67g2000cwd.googlegroups.com> <1165940912.465616.162820@f1g2000cwa.googlegroups.com>
In-Reply-To: <1165940912.465616.162820@f1g2000cwa.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <1165943912.708277@bubbleator.drizzle.com>
Cache-Post-Path: bubbleator.drizzle.com!unknown@oracle.advtechserv.com
X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/)
Lines: 28
X-Complaints-To: abuse@csolutions.net
Xref: usenetserver.com comp.databases.oracle.server:419026
X-Received-Date: Tue, 12 Dec 2006 12:18:33 EST (text.usenetserver.com)

gd6502@eudoramail.com wrote:
> gazzag wrote:
> 
>> select username, osuser, lpad(sid,4)||', '||lpad(serial#, 6) Proc,
>> program, to_char(logon_time, 'DD-Mon-yy HH24:MI:SS') Logon
>> from v$session
>> where username is not null
>> order by username, osuser, Logon;
>>
> 
> It say to me "table or view not exists".
> I already tried something about this, but I can't find the object in
> any schema (I think it should be in SYS). Where can I find it?
> After the object will be found, can I execute the query as a
> non-administrator user?
> Thanks
> 
> Peppe

v$ "magic" views are owned by SYS. You need to have a DBA run the
query for you.
-- 
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org