Oracle-L: RE: slightly OT, permissions unix/oracle puzzler

From: Kathy Duret <KathyD_at_belkin.com>
Date: Mon, 08 Jul 2002 15:28:19 -0800
Message-ID: <F001.00491D50.20020708152819@fatcity.com>

Ok but why would I create a new group? Couldn't I just chmod the permissions on the directory directly?

I understand what your saying but my problem is more than just utl_file and it is ok on one system A and not the other system B

oracle dba are the owner and groups on BOTH systems.

If I go in OEM and create a file under my oracle directories

The one system A creates it as :

-rw-rw---- 1 oracle dba 24576 Jul 8 15:07 TEST2.dbf

The other System B as
-rw-r----- 1 oracle dba 24576 Jul 8 15:07 TEST2.dbf

I have the same problem with utl_file writing to directories oracle dba and I cannot change the owner and/or groups on these directories. They have to remain oracle dba

The .profiles are the same the umasks are the same. They both are solaris. The only difference I can see is that System B sits on Netapp filer.

Is there something that might have been done to the owner oracle or group dba that sets the permissions on all the directories as rw vs r?

I know someone on System A didn't go through and change all the permission on the directories to make things rw

What does OEM use?

Kathy

-----Original Message-----

Sent: Monday, July 08, 2002 2:18 PM
To: ORACLE-L_at_fatcity.com
Cc: KathyD_at_belkin.com

Kathy,

I'm going to assume that what you're trying to do is create UTL_FILE files that
have group r/w permissions. As others have pointed out, you're being thwarted
by the perms of the oracle process.

Here's how I've overridden that in the past.

Assuming your directory is /u01/utl_file/db01/, create a new group called util_file in unix.

Now change the group and perms on the directory:

chgrp util_file /u01/utl_file/db01/
chmod g+rxs /u01/utl_file/db01/

Now all files created in the /u01/utl_file/db01/ file directory will have a group of util_file with read permission.

Just add the util_file group to users that need access.

Read the chmod man page for details.

Jared

Kathy Duret <KathyD_at_belkin.com>
Sent by: root_at_fatcity.com
07/08/2002 01:07 PM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        slightly OT, permissions unix/oracle puzzler

Ok, I log in as oracle, touch a file I get 664 permission on it.

But when I create a file through OEM or a plsql procedure I get 644 permissions.

My umask is 02.

On another system - solaris everything ok.

Both .profiles are the same.

Sys admins no help.

Any clues?

Thanks,

Kathy

Confidential
This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kathy Duret
INET: KathyD_at_belkin.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).

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