Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Application shows users in system how....?????
If I understand what you are asking correctly hopefully this will help (this
is a suggestion given by the instructor of the Oracle Database
Administration class I tok last week, paraphrased of course).
You grant the priviledges to query the table with password authentication. You them embed the password in your application (assuming a compiled and not interpreted application). This way users can run the application, which will issue the set role command with the password, but it keeps the password unknown to them.
tim.mcconechy_at_runtime.dk wrote in message
<7efde5$qa7$1_at_nnrp1.dejanews.com>...
>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 - 18:54:46 CDT