RDBPROD: OpenVMS File Protections on Oracle Rdb Database Files (Doc ID 1120959.1)

Last updated on MAY 03, 2016

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.2.4 and later
HP OpenVMS Alpha
HP OpenVMS Itanium

Goal

According to the Oracle Rdb Installation and Configuration Guide Release 7.2:

Section B.4 "OpenVMS Protection of Oracle Rdb Files"

Oracle Rdb sets the following OpenVMS default protection for all database files:

SYSTEM:READ,WRITE,EXECUTE,DELETE; OWNER:READ; GROUP: , WORLD:

This affects the following files:

  •   Database root (.RDB) and its associated ACL
  •   Recovery-unit journal (.RUJ)
  •   After-image journal (.AIJ)
  •   Snapshot (.SNP)
  •   Storage area (.RDA)

However, when a database is created, for example:

$ SQL show version;
Current version of SQL is: Oracle Rdb SQL V7.2-410
$ SQL create database filename foo;
$

the OpenVMS protection settings are not as expected.

$ directory/protection

Directory DISK:[DIR]

FOO.RDB;1 (RWED,RW,,)
FOO.SNP;1 (RWED,RW,,)

Total of 2 files.
$

OWNER is set to READ, WRITE rather than just READ. Is this a documentation error, a bug or a system set-up problem?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms