We have a user group ‘norkgrp’ which is having 2 users ‘norkadm’ and ‘oracle’.
Further we have a directory ‘fstf_blobs’ where ‘norkadm’ is the owner and ‘norkgrp’ is the group owner. The permission is set as 770.
We are writing some files in this directory through UTL_FILE functionality of oracle. The owner of files created through UTL_FILE is ‘oracle’ and group owner is ‘dba’. However the procedure gives error when trying to write the files. (Permission issues). As norkgrp is the group owner and ‘oracle’ is part of this group and group is having all permissions, I am not able to understand the reason of the error.
When the change permission of this directory to 777 (others also given all permissions) the procedure runs successfully and creates files with owner as ‘oracle’ and group owner as ‘dba’.
Can somebody have a look & explain.
Last edited by Franklin52; 06-26-2010 at 02:53 PM..
Reason: Remove fonts
You probably will need to restart the database to effectuate the oracle user's membership of norkadm. Also you may want to use
so that any file created in that directory has a group ownership of norkgrp (2770 means the setgid bit gets set)
it is possible that the files were assigned permissions outside a "standard" UNIX permission model and using Access Control Lists. It is a long topic, "man getfacl", or just google it. UNIX Academy had a paper related to their training that describes it well. Also check the directory for a sticky bit. Also, make sure that the files are on the same machine (within the same permission set) and on the same filesystem model (not Samba share, or anything that works outside UNIX permission model).
Hi amro1: If acl's would have been set on the directory, this would mean that user oracle would not be able to write to that directory even with permission 777, which contradicts the OP's information..
Introduction
I have seen some misinformation regarding Unix file permissions. I will try to set the record straight. Take a look at this example of some output from ls:
$ ls -ld /usr/bin /usr/bin/cat
drwxrwxr-x 3 root bin 8704 Sep 23 2004 /usr/bin
-r-xr-xr-x 1 bin bin ... (6 Replies)
Hi All
I am using cygwin and if i type ls -l it is giving like
drwxr-xr-x+ for directories.
My question is what is the meaning of '+' sign at the end?
its not giving that '+' sign for files.
Thank you (1 Reply)
Okay,
this may turn out to be something quite simple, but I haven't found the answer so far:
1) Is it possible to retrieve a list of user(ID) file permissions?
and then...
2) What is the most efficient way to create an alert/error message when/if those file permissions are denied? ... (2 Replies)
Hello all,
Trying to do the following.
1. Run Windows installer from a unix server.
2. Let user run the shortcut but not allow access to the folder where the exe itself is running.
What I have done so far:
1. Copied the application to the server and placed in a folder called "data".... (2 Replies)
Is anyone aware of a tool that would produce a report or an extract file of all users, the files thry are allowed to access and their associated rights permitted (Read,Write etc.) (0 Replies)
Hello,
What does the following mean in terms of file permissions.
-rw-rwSrw- 1 owner group 999 May 25 2004 file_name
What does the "S" stand for.
Thanks in advance for your input. :) (3 Replies)
I am currently running jsp pages on unix server. At the top of my page is the import statement: <%@ page import="survey.*"%>. This imports the survey folder which i have placed in the same directory as my jsp page- jsp-servlet.
However, when i try to run the page, its gives me an error saying that... (2 Replies)