Re: How can allow only one user connect to database

Never worked with, but what about oracle connection manager? There should be MAXIMUM_RELAYS parameter fits to your needs, if it works on instance level.
Better look up oracle documentation for that stuff.

Second try - what about an AFTER LOGON ON DATABASE Trigger, but you'll to have ADMINISTERDATABASE TRIGGER privilege? Then you could code a check and if another connection is established/active (using a query or specific table for your stuff) you can raise an exception and disconnect, while give back a user defined message. Disadvantage: you can not block connection before trigger execution, so it may be not the right layer to react.

However - I still wonder, what for you could need such kind of restrictions ;-)

Regards

gang36_at_hotmail.com (hank) wrote in message news:<8d54c48d.0201211556.70e27e69_at_posting.google.com>...
> My case is that when a user (user A) logon a database, this user will
> have all database control and another user can't logon the database
> before the user (user A) release this database, who logon first who
> got the control.
>
> Any help will be great.
>
> Thanks
>
> Gang Huang
Received on Tue Jan 22 2002 - 17:24:41 CET