Re: logon script

From: Paul Drake <drak0nian_at_yahoo.com>
Date: 2 Apr 2003 06:27:55 -0800
Message-ID: <1ac7c7b3.0304020627.fd3b375@posting.google.com>

b_map_at_hotmail.com (bb) wrote in message news:<4a6ed956.0304020048.4481bf5c_at_posting.google.com>...
> i want to make a logon script which checks if the logon id you use to
> logon to the database (8i) is the same as the userid you used to login
> to your operating system (NT). Any ideas? I don't want that logon
> automatically using External Authentication i just want oracle to
> verify that a user uses the same userid for both operating system and
> database.

check out the sys_context function.
the column v$session.osuser has the info that you're looking for.

here is an example on tom Kyte's page: (search for sys_context logon trigger)
http://asktom.oracle.com/pls/ask/f?p=4950:8:216377931783305831::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:7645278048832,

Paul Received on Wed Apr 02 2003 - 08:27:55 CST