Run stored procedure on logon to oracle 7.3.3.6 database

Hello,

I would like to execute a stored procedure, whenever someone log's into the database.
This procedure must be the first to execute. The procedure execute's for every user who logs into the database. It checks if the user has already a
session in the database, if so, he must be rejected with that session.

The check and killing of the session is not the problem. The problem is how to execute the stored proecedure (or
something else) as the first process by logon into the database.

Has anyone the answer to my problem?.

Thanks.

Best regards

michel.lentelink_at_intervet.akzonobel.nl Received on Mon Jul 12 1999 - 02:51:13 CDT