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.