Privileges -- Fields and controls

User page

Group page

Privileges -- User

Add user

Grant all

Revoke all

Privileges

OK

Cancel

Apply

Reset

Show SQL

Add user

Click on this push button to open the Add User window from which you can select users that you want to list in the User column on the User page of the Schema Privileges notebook. From the User column, you can select the users and grant or revoke their privileges for the schema.

Grant all

Click on this push button to grant privileges to all users or groups selected. A check mark indicates that a privilege was granted. A double check mark indicates that users were granted that privilege with the ability to grant the same privilege to others.

The Grant all push button opens the Select Grant Option window. On the Select Grant Option window, select a radio button to indicate whether or not you want to give granting privileges to the selected users. Click on the With Grant option radio button (default) or the No Grant option radio button.

Revoke all

Click on this push button to revoke privileges for all users or groups selected. Revoked privileges are indicated by anX.

Privileges

Use these boxes to grant or revoke the schema privileges for selected users or groups. Click on the down arrow of the CREATEIN, DROPIN, or ALTERIN box and select Yes to grant or No to revoke the privilege. Select Grant to grant the privilege with the ability to grant.

The icons in the columns will show a check mark to indicate that a user has the privilege, a double check mark to indicate that the user has the privilege with the ability to grant, or an X to indicate that the user does not have the privilege.

The privileges for schemas are:

CREATEIN

Grants the privilege to create objects in the schema. Other authorities or privileges (such as CREATETAB) are still required to create the object. The owner of an explicitly created schema automatically receives the CREATEIN privilege. An implicitly created schema has the CREATEIN privilege automatically granted to PUBLIC.

DROPIN

Grants the privilege to drop any object in the schema. The owner of an explicitly created schema automatically receives the DROPIN privilege.

ALTERIN

Grants the privilege to alter or comment on any object in the schema. The owner of an explicitly created schema automatically receives the ALTERIN privilege.

Privileges -- Group

Add group

Grant all

Revoke all

Privileges

OK

Cancel

Apply

Reset

Show SQL

Add group

Click on this push button to open the Add Group window from which you can select groups that you want to list in the Group column on the Group page of the Schema Privileges notebook. From the Group column, you can select groups and grant or revoke privileges for the schema.

Grant all

Click on this push button to grant privileges to all users or groups selected. A check mark indicates that a privilege was granted. A double check mark indicates that users were granted that privilege with the ability to grant the same privilege to others.

The Grant all push button opens the Select Grant Option window. On the Select Grant Option window, select a radio button to indicate whether or not you want to give granting privileges to the selected users. Click on the With Grant option radio button (default) or the No Grant option radio button.

Revoke all

Click on this push button to revoke privileges for all users or groups selected. Revoked privileges are indicated by anX.

Privileges

Use these boxes to grant or revoke the schema privileges for selected users or groups. Click on the down arrow of the CREATEIN, DROPIN, or ALTERIN box and select Yes to grant or No to revoke the privilege. Select Grant to grant the privilege with the ability to grant.

The icons in the columns will show a check mark to indicate that a user has the privilege, a double check mark to indicate that the user has the privilege with the ability to grant, or an X to indicate that the user does not have the privilege.

The privileges for schemas are:

CREATEIN

Grants the privilege to create objects in the schema. Other authorities or privileges (such as CREATETAB) are still required to create the object. The owner of an explicitly created schema automatically receives the CREATEIN privilege. An implicitly created schema has the CREATEIN privilege automatically granted to PUBLIC.

DROPIN

Grants the privilege to drop any object in the schema. The owner of an explicitly created schema automatically receives the DROPIN privilege.

ALTERIN

Grants the privilege to alter or comment on any object in the schema. The owner of an explicitly created schema automatically receives the ALTERIN privilege.

With Grant option

Select this radio button to grant all the privileges with the ability to grant the privilege to others. A double check mark under the privilege indicates the ability to grant that privilege to others.

No Grant option

Select this radio button to indicate that the privileges will be granted without the ability to grant those privileges to others. A single check mark under the privilege indicates that the privilege was granted.