RE: datafile permissions

  • From: "Khemmanivanh, Somckit" <somckit.khemmanivanh@xxxxxxxxxxxxxxxx>
  • To: <raja4list@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 5 Jul 2005 14:28:22 -0700

 
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 

Other related posts: