To get an instance wide logon check use 'after logon on database'
To get the user use sys_context('USERENV', 'OS_USER') or just USER for the
db user
To get the ip address use sys_context('USERENV', 'IP_ADDRESS')

Richard Quintin
VTLS, Inc.
http://www.vtls.com/

> -----Original Message-----
> From: Kate Monro [mailto:[Email Address Removed] Sent: Wednesday, July 31, 2002 12:22 PM
> To: LazyDBA.com Discussion
> Subject: RE: security: restrict username by IP
>
>
> ok. I'm looking into it. It will work if I can do an instance wide logon
> check to see what the IP/username combo is, and deny access from
> that IP for
> any user but the one I want.
>
>

Oracle LazyDBA home page