Re: Stop users from connecting to database

Lots of ways to do everything ...

It would be nice if you could just easily run the batch jobs on the server and disable/stop the listener. This is clean and simple, but I know in our environment it would not be possible.

If this is not possible in your environment, then another possible solution is if you are on Oracle8i or 9i, then create a database level logon trigger to check the account logging in and not allow them to logon unless from a specific Oracle account . Actually, there are other things (a few in 8i and more in 9i) you could check to determine if the logon session is a batch job.

-- 

"Bernd Sandmann" <b.sandmann_at_gmx.net> wrote in message
news:3eca0d95.363278468_at_127.0.0.1...


> Hello,

>

> what is the best way to avoid users from connecting to a database but

> some other users should connect anyway.

>

> The reason for this is that some batch jobs should run under a special

> users while other users should not connect to the database.

>

> regards.

> Bernd Sandmann

>