Re: Restrict TOAD from accessing a DB?

From: <bsc7080mqc_at_oracle.mylxhq.com>
Date: Thu, 06 Mar 2003 06:45:52 -0500
Message-ID: <7oG9a.16652$zm6.16275@fe09.atl2.webusenet.com>

On 5 Mar 2003 12:01:44 -0800, navaed7024_at_hotmail.com (E. Navarro) wrote:

>Does anyone know of a solution to prevent users from logging into a
>database with certain applications. In my case, I want to prevent users
>from logging into our production databases using TOAD.
>

Under toad 7.3 and beyond, you can use the TOAD security (you have to run a script to get it installed first, which comes with TOAD). This security allows you to essentially remove all capabilities from TOAD with regards to database usage. Trust me... it works great. After I turned our DBA's on to it, they locked us down hard in production, though in our case, we have a read only schema, which they do give us permission to execute queries, just no write capabilities via TOAD.

BChase
MylxHQ - Oracle Resource Portal [oracle.mylxhq.com] Received on Thu Mar 06 2003 - 05:45:52 CST