Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news.he.net!cyclone-sf.pbi.net!64.42.15.2!HSNX.atgi.net!news.kjsl.com!lumberjack.rand.org!news Newsgroups: comp.databases.oracle.server From: "Hanser, Larry" Subject: controlling perl access to oracle db Message-ID: Sender: "Hanser, Larry" Date: Mon, 11 Nov 2002 11:29:55 -0800 MIME-Version: 1.0 Lines: 30 X-Newsreader: Microsoft (R) Exchange Internet News Service Version 5.5.2653.11 Content-Type: text/html; charset="iso-8859-1" Xref: newsfeed1.easynews.com comp.databases.oracle.server:166573 X-Received-Date: Mon, 11 Nov 2002 12:56:49 MST (news.easynews.com)

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