Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Run stored procedure on logon to oracle 7.3.3.6 database
Hi Michel,
This is possible, though in quite a different way you describe it.
You should look into creating a profile. In profiles you can limit the
number of sessions per user. Refer to the CREATE PROFILE command,
sessions_per_user clause.
Of course, the end-user will be confronted with a cryptic error message,
before he is disconnected.
Hth,
Sybrand Bakker, Oracle DBA
Michel Lentelink <michel.lentelink_at_intervet.akzonobel.nl> wrote in message
news:37899e76.0_at_gaspra.oss.akzonobel.nl...
> 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:58:18 CDT