From one sleepy brain to another - I agree.

Rob Vorbroker
--- Andrew Hamm <ahamm@mail.com> wrote:
> Ronald Cole wrote:
> >
> > A "single user" mode... and I vote for the
> "informix" user instead of
> > DBA.
>
> Ummmmm, I don't.
>
> I try to convince all our teams/sites to use a
> specific
> application-administration account so that they do
> not use "informix" or
> (horror) "root" to administer the database. The
> principle is:
>
> 1) "root" administers the machine. It should not be
> used to configure the
> engine, the application, or do ordinary user work
> because it puts the
> machine in greater risk of accidental damage by
> sleepy brains.
>
> 2) "informix" administers the engine - space,
> configuration state. It
> should not be used to configure the engine, the
> application, or do ordinary
> user work because it puts the machine in greater
> risk of accidental damage
> by sleepy brains.
>
> 3) the application account administers the database
> - eg schema, mass data
> transformations, etc. It should not be used to do
> ordinary user work
> because it puts the machine in greater risk of
> accidental damage by sleepy
> brains.
>
> Sure, "informix" should be on the list of legal
> administrators, but perhaps
> we need a list of accounts that can connect whilst
> the engine is in the
> hypothetical administration mode.
>
>


=====
Rob Vorbroker Phone: 513/336-8695
Vorbroker Consulting, Inc. Fax: 513/336-6812
www.vorbroker.com robv@vorbroker.com

__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html
sending to informix-list