Re: questions: security on the unix

Manoharan manoharp_at_ongcmds.com

All oracle files on AIX shall have 640 with oracle as owner and the group dba. Rest is taken care by the ORACLE as per the profile of individual oracle user.

• manohar ---

Anderson, Brian wrote:

> Mine are all 640.
>
> Check who owns the datafiles.
>
> ****************************************
> Brian L. Anderson
> Flunky/SA/DBA
> Darton College
> andersob_at_mail.dartnet.peachnet.edu
> ----------------------------------------
>
> > -----Original Message-----
> > From: Mitchell [mailto:mitchell_at_comnet.ca]
> > Sent: Friday, February 23, 2001 1:32 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: questions: security on the unix
> >
> >
> > DBAs
> >
> > Whis is right security for oracle datafile. 640 or 777 or others.
> >
> > I found today in my AIX that some oracle datafile is 777 or
> > some are 660.
> > But when I chmod 644 for those 777 files. The user could not
> > do update and I
> > had to change back. what is wrong
> >
> > How about sys file. Mine is 666 currently. I think should be
> > 640. Any idea?
> >
> > Mitchell
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Mitchell
> > INET: mitchell_at_comnet.ca
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Anderson, Brian
> INET: andersob_at_mail.dartnet.peachnet.edu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: manoharp
  INET: manoharp_at_ongcmds.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).