Re: oracle and his primary group : oinstall or dba

From: John L <jl_at_lammtarra.fslife.co.uk>
Date: Thu, 7 Nov 2002 00:22:42 -0000
Message-ID: <aqcbk7$qbd$1@news8.svr.pol.co.uk>

"Fleury Marcel" <marcel.fleury_at_bluewin.ch> wrote in message news:f18358b2.0211060702.6c96f971_at_posting.google.com...
> Hello,
> Oracle recommands to have oinstall as primary group for oracle account.
> Why not using dba as primary group ?
> What are the benefit to use oinstall instead of dba ?
>

The oracle user is in the oinstall group, and the other users with dba privileges are not, they are in the dba group. The oracle (oinstall) user is the owner of all the oracle files.

In many companies, the sys admin will install the software (as oracle in the oinstall group) and the DBAs (in the dba group) use it.

It also means that the DBAs cannot accidentally remove oracle files.

One way of undoing this "separation of powers" is for oracle to also be in the dba group and to be used by DBAs.

John. Received on Wed Nov 06 2002 - 18:22:42 CST