Manoharan  [EMAIL PROTECTED]

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
>  [EMAIL PROTECTED]
> ----------------------------------------
>
> > -----Original Message-----
> > From: Mitchell [mailto:[EMAIL PROTECTED]]
> > 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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to