Re: current users enquiry

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