RDB/VMS Relational Database Operator DELETE_PROTECTION — VMS RDB_4.0
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:
Format
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:
relation-nameview-namefield-namesequence-numberidentifier
relation-name
The name of the relation for which you want to delete an ACL entry.
view-name
The name of the view for which you want to delete an ACL entry.
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.
sequence-number
A number that identifies the entry within the specified access control list whose protection you want to change.
identifier
A VMS user identifier that designates the entry within the specified access control list whose protection you want to change.
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].
More
You must have the Rdb/VMS 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, 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.