RE: developers privileges in TEST
- From: "Mercadante, Thomas F \(LABOR\)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <JBECKSTROM@xxxxxxxxx>, "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 1 Feb 2007 15:22:22 -0500
Jeff,
In development, developers have insert, update, delete & select on all
of the schema objects via roles. Execute on packages also. Some
actually have personal copies of entire schema's that they can wack away
at. But the prime development schema we control very closely.
In staging (test) & Production, they have select only.
I'm with the others here. Development is a play land. Other
environments are for the application & end users to play with.
Tom
--------------------------------------------------------
This transmission may contain confidential, proprietary, or privileged
information which is intended solely for use by the individual or entity to
whom it is addressed. If you are not the intended recipient, you are hereby
notified that any disclosure, dissemination, copying or distribution of this
transmission or its attachments is strictly prohibited. In addition,
unauthorized access to this transmission may violate federal or State law,
including the Electronic Communications Privacy Act of 1985. If you have
received this transmission in error, please notify the sender immediately by
return e-mail and delete the transmission and its attachments.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jeffrey Beckstrom
Sent: Thursday, February 01, 2007 2: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
Other related posts:
