Path: text.usenetserver.com!out01b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!f1g2000cwa.googlegroups.com!not-for-mail
From: gd6502@eudoramail.com
Newsgroups: comp.databases.oracle.server
Subject: Re: current users enquiry
Date: 12 Dec 2006 08:28:32 -0800
Organization: http://groups.google.com
Lines: 19
Message-ID: <1165940912.465616.162820@f1g2000cwa.googlegroups.com>
References: <1165916955.301010.285640@n67g2000cwd.googlegroups.com>
   <1165926530.064837.309420@n67g2000cwd.googlegroups.com>
NNTP-Posting-Host: 85.47.111.106
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1165940918 20771 127.0.0.1 (12 Dec 2006 16:28:38 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 12 Dec 2006 16:28:38 +0000 (UTC)
In-Reply-To: <1165926530.064837.309420@n67g2000cwd.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; it; rv:1.8.1) Gecko/20061010 Firefox/2.0,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: f1g2000cwa.googlegroups.com; posting-host=85.47.111.106;
   posting-account=Am03cgwAAAAMrNtvlHdlu7AVqmgWrbfr
Xref: usenetserver.com comp.databases.oracle.server:419016
X-Received-Date: Tue, 12 Dec 2006 11:28:38 EST (text.usenetserver.com)

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