Application shows users in system how....?????

I want to show the users in my system:
So I use:
select username,LOGON_TIME from v$session where type='USER' and schemaname='SYSADM'

But what if the user does not have access to this table and what about DB performance querying this.

First of all only privilaged users can run the command and I could make sure they have select on V$session.

But I want to know if there is a better way to get this info without v$ tables.....

Just need user,logon_time

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Apr 07 1999 - 05:52:55 CDT