Re: Keeping users out
- From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- To: Sharon.Kovac@xxxxxxxxxxxxxxx
- Date: Mon, 23 Nov 2009 17:21:59 +0100
Sharon
The easiest solution is probably to create a role, and grant that to your
super users.
Then create a logon trigger that checks if the user has this role upon
connect. If he does, he can log on, otherwise he gets an error message
(raise_application_error does that job nicely).
Be careful though, that they should not have the administrate database
trigger system privilege, as that allows them to bypass errors in logon
triggers.
So when your maintenance window begins, you simple enable the trigger, kill
all existing users, and disable it again after being done with your
maintenance
Just a quick idea off the top of my head
Stefan
=========================
Stefan P Knecht
CEO & Founder
s@xxxxxxxx
10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland
Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info@xxxxxxxx
http://www.10046.ch
=========================
On Mon, Nov 23, 2009 at 5:16 PM, <Sharon.Kovac@xxxxxxxxxxxxxxx> wrote:
>
> Hi everyone,
>
> Currently, we have Sunday mornings reserved for maintenance/updates/
> whatever we need. This has worked great in the past. However, our site in
> Australia has added a third shift on Sunday night which is 7am my local
> time, right in the middle of our maintenance window. I'm looking for
> suggestions as to how to keep users out even though the database and the
> E-Business Suite are up. The twist that makes this difficult is that I
> still need the db and the apps available for my local super-users. For
> example, I recompile some packages, alter some tables and add a new form.
> Now I need the super-users to test the changes that I just made. How can I
> allows those users in and keep the Aussies out? Is there a hardware
> solution?
>
> Thanks!
> Sharon
>
>
> *Sharon Kovac* | RotoMetrics
> Phone: +1 636 587 3600 | Fax: +1 636 587 3701
> 800 Howerton Lane | Eureka, MO 63025 | USA <http://www.rotometrics.com/>
> www.rotometrics.com
>
>
>
>
> ---------------------------------------------------------------------
> This e-mail message is intended only for the personal use of the
> recipient(s) named above. This message is confidential. If you are not an
> intended recipient, you may not review, copy or distribute this message. If
> you have received this communication in error, please notify the sender
> immediately by e-mail and delete the original message.
> ---------------------------------------------------------------------
>
> .
>
Other related posts:
