Re: developers privileges in TEST

  • From: "GovindanK" <gkatteri@xxxxxxxxxxx>
  • To: JBECKSTROM@xxxxxxxxx, "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 01 Feb 2007 13:14:24 -0800

All these "ANY" privileges should be granted with caution. In some cases we 
give the schema owner password to the Team Lead and he/she decides which 
developer will have it. Or else we create individual user accounts and grant 
sel/ins/del/upd through roles and pvt.synonyms ; The developers in few cases 
keep their own version of the package/procedure. The only possible catch is 
when they test dynamic sql (i am not 100% sure on this, i would like you verify 
this prior to proceeding) in which case direct dml privs would need to be 
granted and not thru a role.

Since i donot like cross posting across oracle forums i have removed all other 
than oracle-l (my favorite list).


On Thu, 01 Feb 2007 14:33:15 -0500, "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx> 

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: