Funnily I did recently get certified as an Oracle DBA (for what that's worth!)
but actually I'm a developer who has got more involved in the dba stuff over
time, mainly because of the performance problems suffered by various employers.
I'm a fan of Tom Kyte's writings (eg
http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:25405782527721)
- although I'm sure they aren't to everyone's taste - but have never actually
seen all of his recommendations implemented.
However, I've experienced the repercussions of trying to work with systems in
which (for example) the database doesn't know who is logged in. It can really
make tracing, tuning & auditing much more difficult than it needs to be!
I guess that initially I was interested in seeing what was involved in
implementing a system which followed the Oracle recommendations.
> Date: Tue, 21 Dec 2010 19:31:26 -0500
> Subject: Re: Oracle & Wicket Starter Application Project
> From: ja...@carmanconsulting.com
> To: users@wicket.apache.org
>
> Let me guess, you're a dba?
> On Dec 21, 2010 5:14 PM, "Andrew Hall" <andre...@hotmail.com> wrote:
> >
> > Hi,
> > I've put together a project based on Wicket & Oracle which I'd hope could
> serve as a good starting point for applications based on these 2
> technologies.
> > My background is in writing large applications based upon Oracle & I wrote
> this to learn about Wicket & Java and also to prove to myself that best
> practices from the database world - which sadly I've rarely seen implemented
> in modern web applications! - such as:
> > - using individual database users to represent real users - giving
> end-to-end authentication & allowing the use of features such as SQL Trace &
> fine grained auditing
> > - using database roles to restrict access to data, and not relying wholly
> on application enforced security
> > are compatible with modern web application frameworks. Wicket definitely
> didn't give me too many headaches!
> > It's on github at:
> > https://github.com/andrewah/Wicket---Oracle-Template
> > It'd be fair to say that some of my Java may not be of the highest
> standard, so if anyone has the inclination to look at this, any constructive
> feedback would be appreciated.
> > Cheers,
> > Andrew.
