First off, I can't answer any OEM questions.
I don't use it, and don't care to.
You can probably do this without changing the group of the directory, but
then
all users wishing to access it would require membership in the dba group.
This is ok as long as only DBA's are accessing the files.
Probably not what you want if duhvelopers need access.
Jared
Kathy Duret <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/08/2002 04:28 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: slightly OT, permissions unix/oracle puzzler
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: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
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 <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/08/2002 01:07 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
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: [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).
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: [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:
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).
