Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Application shows users in system how....?????
On Wed, 07 Apr 1999 10:52:55 GMT, tim.mcconechy_at_runtime.dk wrote:
>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
You could create a view using the v$_session table in a schema that has select privleges, then grant access to this view to the other users.
--
Mark Wagoner
To reply, remove no.spam from my e-mail address
Received on Wed Apr 07 1999 - 07:58:44 CDT