Re: current users enquiry

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 Received on Tue Dec 12 2006 - 10:28:32 CST