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].
1 – Format
(B)0[m[4mDELETE[m [4mPROTECTION[m FOR qqqqk
x
lqqqqqqqqqqqqqqqqqqqqj
mqqqqwqqq> [4mDATABASE[m qqqqqqqqqqq>qqqqqqqqqqqqqqqqqk
tqqq> [4mRELATION[m qq> relation-name qqqqqqqqqqqu
tqqq> [4mVIEW[m qqqqqq> view-name qqqqqqqqqqqqqqqu
mqqq> [4mFIELD[m q> field-name [4mIN[m relation-name qu
lqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
mqqqqwqqqqqqqqqq>qqqqqqqqqqqqqwq> .
tqqq> sequence-number qqqu
mqwq> identifier qqqqqqwqj
mqqqqqqqq + <qqqqqqqqj
1.1 – relation-name
The name of the relation for which you want to delete an ACL
entry.
1.2 – view-name
The name of the view for which you want to delete an ACL entry.
1.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.
1.4 – sequence-number
A number that identifies the entry within the specified access
control list whose protection you want to delete.
1.5 – 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].
3 – 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.