HELPLIB.HLB  —  RMU72  Open  Command Qualifiers, Access
    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.
Close Help