Permissions question

  • From: "Sweetser, Joe" <JSweetser@xxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 14 Jan 2008 09:14:05 -0700

New server.  RH 5.  10gR2.

Oracle account was set up a default group of oracle (not dba, though the
dba group does exist).  Foolhardy DBA (moi) did not check the group
before installing the s/w and creating the database.  I would like to
"correct" this as quickly as possible and wonder what anyone thinks
about the following idea:

1. Shutdown everything
2. Get the default group changed to dba in /etc/passwd.  I know I can
change the group when I am logged in, but want to make it "clean" for
everyone going forward.
3. Do a chgrp -R dba on ALL oracle-related files including ORACLE_HOME
and all the datafiles
4. Restart

Thanks,
-joe
 
Confidentiality Note: This message contains information that may be 
confidential and/or privileged. If you are not the intended recipient, you 
should not use, copy, disclose, distribute or take any action based on this 
message. If you have received this message in error, please advise the sender 
immediately by reply email and delete this message. Although ICAT Managers, LLC 
scans e-mail and attachments for viruses, it does not guarantee that either are 
virus-free and accepts no liability for any damage sustained as a result of 
viruses.  Thank you.

--
//www.freelists.org/webpage/oracle-l


Other related posts: