Access=Restricted
Access=Unrestricted
Permits the database administrator to open the database
and restrict access to it in order to perform maintenance
operations or to restructure the database without interference
from users who want to gain access. If access is restricted
(Access=Restricted), the DBADM privilege is required for SQL
access to the database. If the Access=Unrestricted qualifier is
specified, users without the DBADM privilege can attach to the
database.
NOTE
Do not confuse the Oracle RMU Access=Restricted qualifier
with the SQL restricted access clause (available for use
with the following SQL statements: ATTACH, CREATE, DECLARE
ALIAS, and IMPORT). When you specify the restricted access
clause in SQL, only one user can attach to the database;
when you specify the Access=Restricted qualifier using
Oracle RMU, any number of users with the DBADM privilege
can access the database.
Furthermore, note that an SQL SHOW DATABASE command
displays the phrase "No Restricted Access" or the phrase
"Restricted Access" if access has been restricted using the
SQL restricted access clause. However, SHOW DATABASE tells
you nothing about whether Oracle RMU has opened a database
with access restricted. Use the RMU Dump command to view the
Oracle RMU access setting.
Refer to the Oracle Rdb SQL Reference Manual for more
information on the SQL restricted access clause.
If you specify the RMU Open command without the Access qualifier,
Oracle RMU opens the database in the same access mode as the last
RMU Open command performed. If the database was last opened as
restricted, issuing the RMU Dump command results in the following
message being displayed:
Access restricted to privileged users
Use this form of the RMU Open command to open the database on
other nodes without changing the access mode.
The access mode is clusterwide and the last mode set with the RMU
Open command is used for the entire cluster.
For example, if you open the mf_personnel database on node A with
the Access=Unrestricted qualifier, and open the same database
on node B with the Access=Restricted qualifier, the database
has restricted access on both node A and node B. However, the
commands do not terminate any user processes that may have gained
access while the database was unrestricted.
The access mode is stored in the database. Consequently, if
the system fails while access is restricted, access remains
restricted unless the unrestricted mode is explicitly requested.
The RMU Backup, RMU Restore, and RMU Copy_Database commands also
preserve the access mode.
The RMU Close command does not alter the access mode. You can
change the mode by using the RMU Open command only. You can use
the RMU Open command to restrict access to any database, whether
it was opened as AUTOMATIC or MANUAL.
The Access qualifier is a positional qualifier.