Oracle-L: RE: Restrict certain database access using 3rd party tools.

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Thu, 03 Oct 2002 08:18:28 -0800
Message-ID: <F001.004DF68A.20021003081828@fatcity.com>

>From the TOAD help file ...

Although TOAD is intended as a developer's tool, TOAD can be made read-only via the two license files that come with TOAD, READONLY.LIC and FULLTOAD.LIC.
TOAD.EXE only reads TOAD.LIC to determine if it is full TOAD or read-only. The license file contains a setting for read-only database access. The network administrator can copy READONLY.LIC over the TOAD.LIC on an individual workstation to make TOAD read-only at that workstation. Remember, the TOAD.LIC file must be in the TOAD folder.

Quest Software

Raj

Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----
Sent: Thursday, October 03, 2002 10:33 AM To: Multiple recipients of list ORACLE-L

Hi All,

We have users that have OPS$ accounts that have full DML privs when they run forms application via citrix. Currently they do not have sqlplus,etc. There is a requirement that some can have sqlplus,toad,etc. I know you can set up security for sqlplus,etc using product_user_profile but is there a way to allow only SELECT when using a 3rd party tool such as TOAD.

Thanks
Rick

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



text/plain attachment: ESPN_Disclaimer.txt

Received on Thu Oct 03 2002 - 11:18:28 CDT