Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!prodigy.com!newsmst01.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr14.news.prodigy.com.POSTED!34d3422d!not-for-mail From: Karsten Farrell User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.1) Gecko/20020826 X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: controlling perl access to oracle db References: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Lines: 24 Message-ID: <_SUz9.1264$i17.54946063@newssvr14.news.prodigy.com> NNTP-Posting-Host: 67.117.210.172 X-Complaints-To: abuse@prodigy.net X-Trace: newssvr14.news.prodigy.com 1037048378 ST000 67.117.210.172 (Mon, 11 Nov 2002 15:59:38 EST) NNTP-Posting-Date: Mon, 11 Nov 2002 15:59:38 EST Organization: Prodigy Internet http://www.prodigy.com X-UserInfo1: FKPGGX_EJ[U]CQ\Y\BCBNWX@RJ_XPDLMN@GZ_GYO^BVNDQUBLNTC@AWZWDXZXQ[K\FFSKCVM@F_N_DOBWVWG__LG@VVOIPLIGX\\BU_B@\P\PFX\B[APHTWAHDCKJF^NHD[YJAZMCY_CWG[SX\Y]^KC\HSZRWSWKGAY_PC[BQ[BXAS\F\\@DMTLFZFUE@\VL Date: Mon, 11 Nov 2002 20:59:38 GMT Xref: newsfeed1.easynews.com comp.databases.oracle.server:166581 X-Received-Date: Mon, 11 Nov 2002 13:59:48 MST (news.easynews.com) Hanser, Larry wrote: > Dear Friends: > > I've constructed a simple program using the perl dbd module to access an > oracle database. I have no intention nor desire to write to the > database, only to read from it. The database owner wants me to use > oracle discoverer in order to restrict me to read-only access, but the > perl access I've developed works just fine for my needs. The database > owner is willing to allow me to use perl if they can "certify" that my > program can't write to the database either inadvertently or on purpose. > > My question: > > Isn't it possible to control write access for a username/password in oracle? > > Thanks > Yes, the schema owner can grant "select only" access privileges to their data. Are you using a unique oracle userid to access the database? The only reason they should have trouble restricting you to "read-only" is if you are using a common userid that is used by other people who need more than read-only. Maybe you should suggest they read up on the GRANT command in the Oracle docs (see http://tahiti.oracle.com).