RE: Unix ownership/group of files created via Oracle

You don't specify what flavor of Unix. Many (most?) flavors will allow you to put the oracle userid into the application group and then follow the group permissions to allow access. This avoids giving the application people r/w on the oracle files.

Try it.

Brian

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of John Dunn
> Sent: Tuesday, January 16, 2001 5:16 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Unix ownership/group of files created via Oracle
>
>
> We have an application where text files are created and read by both Oracle
> processes and an in house application .
>
> Files created by Oracle processes have ownerships of oracle and group dba.
>
> Files created by the in house application are owned by another user and
> group.
>
> Systems admin do not want to make any other user a member of Oracle dba
> group.
>
> Nor do they want to see files with 666 permissions.
>
> What is the usual approach in these situations?
>
> John
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Dunn
> INET: john.dunn_at_sefas.co.uk
>
> 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).
Received on Tue Jan 16 2001 - 08:52:41 CST