Symbols in privileges columns

On the Schema, Table, Index, and View pages, symbols in the privileges columns indicate whether the group already has privileges on the objects that you selected, and whether grants and revocations of privileges are pending or have been made. The symbols are:

• Check marks
• Double check marks
• Xs

Check marks

A check mark framed by corner brackets means that a grant of a privilege, without the Grant option, 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:

• The INSERT privilege on TABLE2
• The right to grant the INSERT privilege on TABLE2 to other groups and users

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 X framed by corner brackets means that the revocation of a privilege is pending (see Example 1), or that the override of a request to grant a privilege is pending (Example 2). An unframed X means that a group doesn't have a particular privilege (Examples 1, 3).

Example 1

INDEX3 is listed in the Index column on the Index page. The selected group has the CONTROL privilege on INDEX3, but no longer needs it. So you decide to revoke it. Accordingly, you select INDEX3 and specify No in the CONTROL box. The revocation that you want is now pending. As a sign of this, an X framed by corner brackets appears across from INDEX3 in the CONTROL column.

Then you click on Apply, and the privilege is revoked. As a sign of this, the corner brackets disappear, leaving the X unframed.

Example 2

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

Example 3

On the View page, you click on the Add View push button. Then, on the Add View window, you select the schema that contains VIEW5, select VIEW5, and click on Add and Close. Consequently, VIEW5 appears in the View column; and unframed Xs appear across from it in the view privileges columns. These unframed Xs mean that the selected group doesn't have any privileges on VIEW5.