RE: developers privileges in TEST
- From: "Kerber, Andrew" <Andrew.Kerber@xxxxxxx>
- To: Ron.Reidy@xxxxxxxxxxxxxxxxxx, JBECKSTROM@xxxxxxxxx, "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>, "oracle-db-l" <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>, "oracle tech-old list" <ORACLE-L@xxxxxxxxxxxxx>, "oracle rdbms group" <oracle-rdbms@xxxxxxxxxxxxxxx>
- Date: Thu, 1 Feb 2007 13:46:38 -0600
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@xxxxxxx
"If at first you dont succeed, dont take up skydiving"
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Reidy, Ron
Sent: Thursday, February 01, 2007 1:39 PM
To: JBECKSTROM@xxxxxxxxx; 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.
rr
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.
==============================================================================
Other related posts:
