Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Online Manual

Media Vault

Software Library

Restoration Projects

Artifacts Sought

Related Articles

Format

Examples

More

relation-name

view-name

field-name

sequence-number

identifier

RDB/VMS Relational Database Operator DELETE_PROTECTION — VMS RDB_4.1_M

 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

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

identifier

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

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.

Typewritten Software • bear@typewritten.org • Edmonds, WA 98026