Symbols in Privileges columns

On the Schema, Table, Index, and View pages, symbols in the privilege columns indicate what privileges a group lacks, what grants of privileges are pending, and what grants have been made. The symbols are:

Check marks
A check mark framed by corner brackets means that a grant of a privilege is pending. An unframed check mark means that a privilege, without the Grant option, has been granted.

Example

SCHEMA1 is listed in the Schema column on the Schema page. You want to grant the CREATEIN privilege on SCHEMA1; so you select SCHEMA1 and specify Yes in the CREATEIN box. Your grant of the CREATEIN privilege is now pending. As a sign of this, a check mark framed by corner brackets appears in the CREATEIN column next to SCHEMA1.

Then you click on Apply, and the privilege, but not the Grant option, is granted. As a sign of this, the corner brackets disappear, leaving the check mark unframed.

Double check marks
A double check mark framed by corner brackets means that a grant of a privilege and the Grant option (the right to grant that privilege to other groups and users) is pending. An unframed double check mark means that a privilege, with the Grant option, has been granted.

Example

TABLE2 is listed in the Table column on the Table page. You want to grant:

Accordingly, you select TABLE2 and specify Grant in the INSERT box. Your grant of the INSERT privilege and the Grant option is now pending. As a sign of this, a double check mark framed by corner brackets appears across from TABLE2 in the INSERT column.

Then you click on Apply, and the privilege, with the Grant option, is granted. As a sign of this, the corner brackets disappear, leaving the double check mark unframed.

Xs
An unframed X in a privilege column means that the group doesn't have the kind of privilege named at the top of the column (see Example 1). An X framed by corner brackets means that the override of a request to grant a privilege is pending (Example 2).

Example 1

On the Index page, you click on the Add Index push button. Next, on the Add Index window, you select the schema to which INDEX3 belongs, select INDEX3, and click on Add and Close. INDEX3 appears in the Index column, and an unframed X appears beside it in the CONTROL column. This X means that the group referenced on the Database page doesn't have the CONTROL privilege on INDEX3.

Example 2

You want to grant the UPDATE privilege on VIEW4. Therefore, on the View page, you select VIEW4 in the View column and specify Yes in the UPDATE box. Then you determine that it would be better to grant the UPDATE privilege to individuals rather than to a group. So you override the Yes, by selecting VIEW4 again and specifying No in the UPDATE box. As a sign that this override is pending, an X framed by corner brackets appears across from VIEW4 in the UPDATE column.