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.  Rdb/VMS access
 control lists are stored in the database file.

 Example:

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

Additional information available:

FormatExamplesMore

 DELETE PROTECTION FOR ────┐
                           │
      ┌────────────────────┘
      └────┬───> 
D
A
T
A
B
A
S
E ───────────>─────────────────┐
           ├───> 
R
E
L
A
T
I
O
N ──> relation-name ───────────┤
           ├───> 
V
I
E
W ──────> view-name ───────────────┤
           └───> 
F
I
E
L
D ─> field-name IN relation-name ─┤
       ┌───────────────<───────────────────────────────┘
       └────┬──────────>─────────────┬─> .
            ├───> sequence-number ───┤
            └─┬─> identifier ──────┬─┘
              └──────── typebox (+) <────────┘

Additional information available:

FIELD field-name IN relation-namesequence-numberidentifier

 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.

 A number that identifies the entry within the specified access
 control list whose protection you want to change.

 A VMS user identifier that designates the entry within the specified
 access control list whose protection you want to change.

 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].

 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, Rdb/VMS
 starts a read/write transaction implicitly.

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