1  DELETE_PROTECTION
   Deletes an entry from the access control list (ACL) for a
   database or relation. An access control list entry specifies the
   operations a user may perform on the associated database element.
   Oracle Rdb access control lists are stored in the database file.

   Example:

   RDO> DELETE PROTECTION FOR RELATION JOB_HISTORY [CLERKS,SMITH].
 

2  Format

 (B)0DELETE PROTECTION FOR qqqqk
                           x
      lqqqqqqqqqqqqqqqqqqqqj
      mqqqqwqqq> DATABASE qqqqqqqqqqq>qqqqqqqqqqqqqqqqqk
           tqqq> RELATION qq> relation-name qqqqqqqqqqqu
           tqqq> VIEW qqqqqq> view-name qqqqqqqqqqqqqqqu
           mqqq> FIELD q> field-name IN relation-name qu
       lqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
       mqqqqwqqqqqqqqqq>qqqqqqqqqqqqqwq> .
            tqqq> sequence-number qqqu
            mqwq> identifier qqqqqqwqj
              mqqqqqqqq + <qqqqqqqqj

 

3  relation-name
   The name of the relation for which you want to delete an ACL
   entry.
 

3  view-name
   The name of the view for which you want to delete an ACL entry.
 

3  field-name
   The name of the local field in a specified relation for which you
   want to delete an ACL entry.

   Rights on a field are determined by the rights defined on the
   relation combined with those specified for the specific relation
   ACL.
 

3  sequence-number
   A number that identifies the entry within the specified access
   control list whose protection you want to delete.
 

3  identifier
   An OpenVMS user identifier that designates the entry within
   the specified access control list whose protection you want to
   delete.
 

2  Examples
   Example 1

   Delete an ACL entry identified by a sequence number:

   RDO> DELETE PROTECTION FOR DATABASE 3.

   This statement deletes an entry identified by sequence number.
   All the entries following the deleted entry are given the next
   lower sequence number.

   Example 2

   Delete an ACL entry identified by a UIC:

   RDO> DELETE PROTECTION FOR RELATION JOB_HISTORY [CLERKS,SMITH].

   This statement deletes the entry identified by [CLERKS,SMITH].
 

2  More
   You must have the Oracle Rdb CONTROL privilege to use the DELETE
   PROTECTION statement.

   Revoking a privilege takes effect after the users detaches and
   attaches to the database again.

   You must execute this statement in a read/write transaction.
   If there is no active transaction and you issue this statement,
   Oracle Rdb starts a read/write transaction implicitly.

   Other users are allowed to be attached to the database when you
   issue the DELETE PROTECTION statement.