In article <1a75df45.0312072144.13965d55_at_posting.google.com>, vslabs_at_onwe.co.za (Billy Verreynne) wrote:
>Daniel Morgan <damorgan_at_x.washington.edu> wrote
>
>> And not once has anyone addressed my statements about granting access to
>> developers to the v$ magic views and many of the DBMS and UTL packages
>> and I would bet a Latte' at Starbucks you don't give your developers
>> access to them either.
>
>Well, on our DEV platform I have given the developer accounts select
>access to the v$ magic views in a vain hope that with a little bit of
>self empowerment, they will get to know Oracle better and even use it
>better.
>
>But then I still get stuff like this in production:
>begin
> insert statement (trigger updates the seq)
>
> select max(seq) into :s from table;
>
> return( :s )
>end;
This isn't evidence of developers that aren't Oracle literate. This is
evidence of under-competent (sic) developers. Code reviews can be mandated by
management--and if a DBA brought this kind of code to a competent IT manager,
he/she should certainly see the need for them.
Received on Mon Dec 08 2003 - 07:47:53 CST
