Symantec logo

Setting administrative permissions

To allow database administrators to administer a database using Veritas Storage Foundation for DB2, you are required to change some permission settings. You are asked during the installation process if you want to allow database administrators access to various functionality. If you did not make the permission changes during installation, you can do so at a later time.

The default settings at installation time for the /opt/VRTSdb2ed directory allow only the root login to access the directory.

 To allow the user "db2inst1" access to the /opt/VRTSdb2ed directory

Use the chown and chmod commands as follows:

# chown db2inst1 /opt/VRTSdb2ed
# chmod 500 /opt/VRTSdb2ed

 To allow users in the group "db2iadm1" access to the /opt/VRTSdb2ed directory

Use the chgrp and chmod commands as follows:

# chgrp db2iadm1 /opt/VRTSdb2ed
# chmod 550 /opt/VRTSdb2ed