Or even against: select count(*) into some_value from v$session where username = user; On 12/9/05, rjamya <rjamya@xxxxxxxxx> wrote: > You could try checking for their OS name instead of oracle username. > > Raj > -- Best regards, Edgar Chupit callto://edgar.chupit -- //www.freelists.org/webpage/oracle-l