(B)0[m[4mCHANGE[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
mqqqwqqqqqqqqqqq>qqqqqqqqqqqwqk
tqq> sequence-number qqqu x
mwq> identifier qqqwqqqqj x
mqqqqqqq + <qqqqqqj x
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
mqq> [4mACCESS[m qqwq> access-right qqwqqqqqqqqqq> .
mqqqqq + <qqqqqqqqqj
1 – relation-name
The name of the Oracle Rdb relation for which you want to change an
ACL entry.
A user with MODIFY rights on the relation automatically gets
the same rights on all fields in the relation. However, you can
restrict MODIFY rights by defining them only on specific fields
you want users to be able to modify and thus remove the right
from the relation entry.
2 – view-name
The name of the view for which you want to change an ACL entry.
3 – field-name
The name of the local field in a specified relation for which you
want to change 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.
4 – sequence-number
A number that identifies the entry within the specified access
control list whose protection you want to change. The default is
one.
If you specify a sequence number larger than the largest existing
sequence number, Oracle Rdb returns an error message.
5 – identifier
An OpenVMS user identifier that identifies the entry within
the specified access control list whose protection you want to
change. An identifier can be any of the following:
o UIC identifier
You cannot specify more than one UIC identifier in a CHANGE
PROTECTION statement.
o General identifier
o System-defined identifier
6 – access-right
An access right to be granted or denied to the user identified
by UIC. The new version of the ACL entry you create with the
CHANGE PROTECTION statement does not inherit any characteristics
from the old version. When you change protection on a database
element, you need to specify the entire entry, including all the
access rights you want to deny.
Request HELP on Access_rights to see a complete table of Oracle Rdb
access rights.