Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: current users enquiry

Re: current users enquiry

From: gazzag <gareth_at_jamms.org>
Date: 13 Dec 2006 02:41:11 -0800
Message-ID: <1166006471.876930.287870@n67g2000cwd.googlegroups.com>


gd6502_at_eudoramail.com wrote:
> So, there is no way for a common user to know if the schema he is using
> is accessed from some other?
>
> Peppe

Depending on what you're trying to achieve, you will need the DBA of that database to either:

(a) Grant you SELECT privileges on the V_$SESSION view, or,

(b) Create a login trigger that logs the information you require.

HTH -g Received on Wed Dec 13 2006 - 04:41:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US