I don't think you have to do anything at the Oracle level. You're moving from more restrictive to less restrictive anyways... Thanks! ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of raja rao Sent: Tuesday, July 05, 2005 2:20 PM To: oracle-l@xxxxxxxxxxxxx Subject: datafile permissions Hi All, Sun OS 2.9 oracle 9i In what state the datafiles should be when i want to change the OS file permissions from 600 to 640 chmod 640 *.dbf I put the tablespace offline. is that enough?, or should i make the datafiles offline withi alter database datafile 'filename' offline; I had a fight with my manager. He asked me to put the datafiles offline using alter database. But Just i put the tablespace offline and did that. Just want to make sure what is the right way (precautiion to be taken) for this task ? Thanks in advance, Raj __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com