RE: developers privileges in TEST

From: Kerber, Andrew <Andrew.Kerber_at_umb.com>
Date: Thu, 1 Feb 2007 13:46:38 -0600
Message-ID: <D40740337A3B524FA81DB598D2D7EBB3057771CC@x6009a.umb.corp.umb.com>

Our developers do not get the 'any' privileges in any environment. That's the only way to make sure that the applications they develop will run properly. Actually, no developer gets any object privilege granted specifically to them, we do all object grants through roles.

Andrew W. Kerber
Oracle DBA
UMB
816-860-3921
andrew.kerber_at_umb.com

"If at first you dont succeed, dont take up skydiving"

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Reidy, Ron Sent: Thursday, February 01, 2007 1:39 PM To: JBECKSTROM_at_gcrta.org; oracle-l-freelists; oracle-db-l; oracle tech-old list; oracle rdbms group
Subject: RE: developers privileges in TEST

Our developers do not get "%ANY%" privileges in any DB instance outside of dev.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeffrey Beckstrom Sent: Thursday, February 01, 2007 12:33 PM To: oracle-l-freelists; oracle-db-l; oracle tech-old list; oracle rdbms group
Subject: developers privileges in TEST

What privileges do you grant in your TEST environments? Do you grant
"insert any table" or do you grant privileges to specific objects?

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

This electronic message transmission is a PRIVATE communication which contains information
which may be confidential or privileged. The information is intended to be for the use of the individual
or entity named above. If you are not the intended recipient, please be aware that any disclosure,
copying, distribution or use of the contents of this information is prohibited. Please notify the sender
of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0),
and then delete it from your system.

NOTICE: This electronic mail message and any attached files are confidential. The information is exclusively for the use of the individual or entity intended as the recipient. If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited. If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 01 2007 - 13:46:38 CST