Alter directory ownership and privileges – Oracle Audio Technologies Retail Data Warehouse 13 User Manual
Page 13
Alter Directory Ownership and Privileges
Database Installation Guide 5
2.
Create RDW database directory structure:
Log in to the database server as UNIX user rdwdba. This user owns the database
directory structure.
Extract the files from the downloaded zip file. FTP (in binary mode) the tar file,
rdw13_db.zip, to
database will be created. The
directory that should be designated at this time. As the rdwdba user, extract the
rdw13_db.zip file by typing the following at the UNIX prompt:
unzip rdw13_db.zip
3.
Create RDW code directory structure:
Log in to the database server as the UNIX user oretail. This user owns the code
directory structure.
FTP (in binary mode) the file rdw13_code.zip to a base directory where you wish
to permanently store the RDW code directory. This base directory should be on
the UNIX server where the RDW database will be created. The base directory is
a working directory that you should designate at this time. As the oretail user,
extract the rdw13_code.zip file in the base directory specified above by entering
the following at the UNIX prompt:
unzip rdw13_code.zip
Note:
It is highly recommended that clients have a separate
server for production installations. To set up a production
environment; create a prd directory, then copy the dev
directory structure to the production server, and use the
structure on that server. A prd group is needed and a
separate prd user should be created as well.
Alter Directory Ownership and Privileges
For added security, alter the directory ownership and privileges.
1.
Log in as the root user (in the
2.
Change the following as indicated in the table below:
the ownership (chown –R
the group (chgrp –R
the privileges (chmod –R
Directory Owner
Group Privilege
retek oretail
dba 775
dev rdw13dev dev
775
dbasql
rdwdba – Oracle
dba
774
For example: cd
chown –R rdw13dev dev
chgrp –R dev dev
chmod –R 775 dev