Re: current users enquiry

gazzag ha scritto:

> 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?
>
> 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.
>

1. I can't grant additional privileges because this must be run dinamically in a lot of different situations. The user is the one created for a specific schema, and doesn't have administration privileges; I feel strange he can't know which clients or applications are accessing his schema.
2. Sorry, but I don't know what's a login trigger and how I can use it. I'll serch something about it. Bye

Peppe Received on Wed Dec 13 2006 - 05:55:35 CST