RE: data file permissions --

SyncSort is NOT a data unloader. It's purpose, and it does a damned good job of it, is to sort large text files to improve data loading with tools like SQL*Loader. Your user should have zero access to the datafiles, period. They need to be -rw-r---- so that an ipc dedicated server process will work. But under NO circumstances should that be changed. Doing so can make for a VERY long night of recovering a database.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
Sent: Tuesday, January 13, 2004 5:14 PM
To: Multiple recipients of list ORACLE-L

Oracle data files are read BY ORACLE SERVER PROCESSES ONLY! The only unloader that reads files directly is the notorious DUL. I haven't had any experiences with DUL, but according to what I know, I wouldn't even want to have it. Now there is a system call named "chmod" and oracle takes care that only oracle RDBMS can access files. Nobody but the DBA can even sniff database files. Please, execute that user.

On 01/13/2004 04:19:25 PM, sat0789_at_fastmail.fm wrote:
> Hello All,
>
> I have a question on data file permissions.
> When i add a new data file, it gets created as -rw-r-----
> Umask for oracle user is 022.
> There is a unix user who wants read access to the data files since they
> are read by fastunload process (syncsort).
> When i do a touch on any file in that same directory the permission
> reads as -rw-r--r-- which coincides with the umask set.
> Could someone please tell me how the data files get -rw-r---- and NOT
> -rw-r--r--.
>
> Oracle file permission reads -rwsr-s--x
>
> Thank You,
>
> Sathish.
>
> --
> http://www.fastmail.fm - Choose from over 50 domains or use your own
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: sat0789_at_fastmail.fm
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
>

--
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: mladen_at_wangtrading.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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.net
-- 
Author: Goulet, Dick
  INET: DGoulet_at_vicr.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).