Solaris

Hi
I have following directory :

Code:

=> ls -ltr
total 0
drwxrwxr-x    2 wmdwhadm dba            8192 Apr 02 23:22 in-process/

=> id wmdwhadm
uid=210(wmdwhadm) gid=1(staff) groups=251(cogadmin)

My first question is although directory belong to dba group, then why "id wmdwhadm" command doesn't show dba group ? I am thinking that user wmdwhadm belongs to dba group. Please help in making me understand.

I ran an Oracle job which creates files in "in-process". But job fails with error:

Code:

"ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 475
ORA-29283: invalid file operation"

Its related to insufficient permission. When i changed permission to 777, job ran successfully.

I noticed that oracle user also belongs to dba group and directory's group is also dba group (as per above ls command).

Code:

=> id oracle
uid=251(oracle) gid=209(dba)

Can you please explain me why job failed given oracle user is in dba group and directory's group is also dba.
(Am i missing some thing in understanding the meaning of dba group in directory listing. ? )

Please help

Thanks.

see man newgrp

This link may help you

What makes you think that the directory ownership should reflect the OS user definition?
Just add the user to the dba group:

Code:

usermod -G cogadmin,dba wmdwhadm

or (if your usermod implementations supports -a append):

Code:

usermod -Ga dba wmdwhadm

hi ankit

i think so dba is secondary group membership
first one is staff group membership