Re: Run stored procedure on logon to oracle 7.3.3.6 database DEEL II

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Mon, 12 Jul 1999 11:39:22 +0200
Message-ID: <931772328.18327.0.pluto.d4ee154e@news.demon.nl>

It is very strange at least.
Is there any change you could look at v$process and v$session to see what is really happening.
issue a statement like
select sid, serial#, program, osuser, schemaname from v$session
My initial reply is this is probably a bug.

Hth,
Sybrand Bakker, Oracle DBA

Michel Lentelink <michel.lentelink_at_intervet.akzonobel.nl> wrote in message news:3789aaa0.0_at_gaspra.oss.akzonobel.nl...
> Hello,
>
> to the person who answered my question the first time.
>
> You said. Use profiles on users, I have tried. I created a test profile
> with the option session_per_user set to 2 and a test user with that
profile.
>
> But when I tried it, I could log into the database at least 3 times (and
> more)
> So is that a bug of oracle or have I forgotten something
>
>
> michel.lentelink_at_intervet.akzonobel.nl
>
>
>
>
>
>
Received on Mon Jul 12 1999 - 04:39:22 CDT