File permissions

dappa_don · 06-01-2009, 05:26 AM

Hi All,

I'm running RHEL 5.1. This is running our oracle databases. When the database creates a file it is not creating the file with r,w,e, permissions. It is creating these files on a nfs share on windows server2003.

does anybody know how to make sure the database is creating these files with permissions of 775 on this filesystem which is mounted from a windows box?

battletroll · 06-01-2009, 01:30 PM

It may be the umask the system is set with or the user oracle is running as.
By default the umask - 0002 for root and 0022 for users.
Try changing this in the /etc/bashrc or and it to the users /home/oracle/.bash_profile

Hope it helps

chrism01 · 06-01-2009, 08:33 PM

MS and Linux perms are very different. What format is this disk; NTFS, VFAT ?

dappa_don · 06-03-2009, 03:58 AM

Its using NTFS.

I have wrote a script to run on this and mod all files but don't want this solution. would setting the UID in this directory solve this issue?

Sm1ler · 06-03-2009, 07:43 AM

How is the NTFS drive or share mounted? If this done via the fstab you can pass various options and set the umask at mount. Also what permissions are set on the mount point and who owns it? it's all worth checking.

dappa_don · 06-05-2009, 09:45 AM

Yeah it's getting mounted via the fstab using:

nfs defaults 0 0

the directory in question is:

drwxrwxrwx 2 nfsnobody nfsnobody 64 Jun 5 07:59

although the mount point is higher in the directory tree but still has the same permissions

drwxrwxrwx 2 nfsnobody nfsnobody 64 Jun 5 12:00