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).
Received on Tue Jan 13 2004 - 16:14:25 CST
