Re: Stop users from connecting to database

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Tue, 20 May 2003 19:11:02 +0200
Message-ID: <u9okcv8aliab54ualgvkavs5vgml08n2ve@4ax.com>

On Tue, 20 May 2003 11:17:24 GMT, b.sandmann_at_gmx.net (Bernd Sandmann) wrote:

>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

grant restricted session privilege to the 'special' users and
alter system enable restricted session
to allow only those users to connect.

Alternatively, just shut down the listener, and run those jobs on the server directly.
This might be a less silly procedure than the one outlined by Mr Cowell

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue May 20 2003 - 12:11:02 CDT