(B)0[m[4mSHOW[m [4mPRIVILEGES[m FOR qqqqk
lqqq<qqqqqqqqqqqqqqqj
mqqqqwqqq> [4mDATABASE[m qqqqqqqqqqq>qqqqqqqqqqqqqqqqqwqqq>
tqqq> [4mRELATION[m qq> relation-name qqqqqqqqqqqu
tqqq> [4mVIEW[m qqqqqq> view-name qqqqqqqqqqqqqqqu
mqqq> [4mFIELD[m q> field-name [4mIN[m relation-name qj
Displays your access control list (ACL) entry when Oracle Rdb
matches your UIC with the identifier specified in the ACL entry
(ACE). Although your UIC may match many ACL entries, Oracle Rdb
stops when it finds the first match and grants you those access
rights.
You can display your particular privileges for the database,
a relation, or a view. Note the difference between the SHOW
PRIVILEGES and SHOW PROTECTION statements. The SHOW PROTECTION
statement displays all ACL entries. The SHOW PRIVILEGES statement
displays only your ACE or the privileges you have to a database
object as a result of holding one or more of the OpenVMS or
Oracle Rdb overriding privileges.
You must have the Oracle Rdb READ privilege for a database to use
the SHOW PRIVILEGES statement.
1 – More
You must invoke a database before you issue the SHOW PRIVILEGES
statement.
The display for the SHOW PRIVILEGES statement reflects
information stored following a COMMIT or ROLLBACK statement
and a detach from the database with a FINISH statement. Unlike
the SHOW PROTECTION statement, SHOW PRIVILEGES will not reflect
uncommitted changes. Any changes you make to your privileges or
those of other users do not take effect until you detach from the
database.
In order to perform a certain operations, you must have
the correct access mode privilege (READ, WRITE, MODIFY, or
ERASE) on both the database and the relation. Therefore, the
SHOW PRIVILEGES display for a relation will drop any access
mode privileges that are not present for the database before
displaying the privileges for the relation.
If you hold one or more of the OpenVMS override privileges
(SYSPRV, OPER, or SECURITY) or one or more of the Oracle Rdb role-
oriented privileges (ADMINISTRATOR, OPERATOR, or SECURITY),
you are implicitly granted privileges to database objects as
a result of an ACL override. You operate as if you actually
hold the privileges you are implicitly granted, even though
these privileges are not stored in the ACL. The SHOW PRIVILEGES
statement displays the privileges you have to a database object
as a result of holding the OpenVMS override privilege or Oracle Rdb
role-oriented privilege.
The SHOW PRIVILEGES statement displays only those privileges that
are valid for the database object. For example, although you may
hold the Oracle Rdb ADMINISTRATOR, OPERATOR, or SECURITY database
privileges, these privileges are not displayed when you issue
the SHOW PRIVILEGES statement for a relation because they are not
relation privileges.