Authorities -- Fields and controls

User page

Group page

User page

Add user

Grant all

Revoke all

Authorities

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 Database Authorities notebook. From the User column, you can select the users and grant or revoke their authorities for the database.

Grant all

Click on this push button to grant authorities to all users or groups selected. A check mark indicates that an authority was granted.

Revoke all

Click on this push button to revoke authorities for all users or groups selected. Revoked authorities are indicated by an X.

Authorities

Use these boxes to grant or revoke the database authorities for selected users or groups. Click on the down arrow of the DBADM, CREATETAB, BINDADD, CONNECT, NOFENCE, or IMPLICITSCHEMA box and select Yes to grant or No to revoke the authority.

The icons in the columns will show a check mark to indicate that a user has the authority or an X to indicate that the user does not have the authority.

The authorities for databases are:

DBADM

Grants the database administration authority. A database administrator has all privileges against all objects in the database and may grant these privileges to other users or user groups.

BINDADD, CONNECT, CREATETAB, and NOFENCE are automatically granted to an authorization name that is granted DBADM authority.

CREATETAB

Grants the authority to create base tables within the database. The creator of a base table automatically has the CONTROL privilege on that table. The creator retains this privilege even if the CREATETAB authority is subsequently revoked.

BINDADD

Grants the authority to create packages in the database. The creator of a package automatically has the CONTROL privilege on that package and retains this privilege even if the BINDADD authority is subsequently revoked.

CONNECT

Grants the authority to access the database.

NOFENCE

Grants the authority to register functions that execute in the database manager's process (CREATE_NOT_FENCED authority). After a user registers a function as not-fenced, it continues to run in the database manager's process even if CREATE_NOT_FENCED authority is revoked.

IMPLICITSCHEMA

Grants the authority to create a schema for an object by specifying the schema's name in the definition of the object.

Group page

Add group

Grant all

Revoke all

Authorities

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 Database Authorities notebook. From the Group column, you can select groups and grant or revoke authorities for the database.

Grant all

Click on this push button to grant authorities to all users or groups selected. A check mark indicates that an authority was granted.

Revoke all

Click on this push button to revoke authorities for all users or groups selected. Revoked authorities are indicated by an X.

Authorities

Use these boxes to grant or revoke the database authorities for selected users or groups. Click on the down arrow of the DBADM, CREATETAB, BINDADD, CONNECT, NOFENCE, or IMPLICITSCHEMA box and select Yes to grant or No to revoke the authority.

The icons in the columns will show a check mark to indicate that a user has the authority or an X to indicate that the user does not have the authority.

The authorities for databases are:

DBADM

Grants the database administration authority. A database administrator has all privileges against all objects in the database and may grant these privileges to other users or user groups.

BINDADD, CONNECT, CREATETAB, and NOFENCE are automatically granted to an authorization name that is granted DBADM authority.

CREATETAB

Grants the authority to create base tables within the database. The creator of a base table automatically has the CONTROL privilege on that table. The creator retains this privilege even if the CREATETAB authority is subsequently revoked.

BINDADD

Grants the authority to create packages in the database. The creator of a package automatically has the CONTROL privilege on that package and retains this privilege even if the BINDADD authority is subsequently revoked.

CONNECT

Grants the authority to access the database.

NOFENCE

Grants the authority to register functions that execute in the database manager's process (CREATE_NOT_FENCED authority). After a user registers a function as not-fenced, it continues to run in the database manager's process even if CREATE_NOT_FENCED authority is revoked.

IMPLICITSCHEMA

Grants the authority to create a schema for an object by specifying the schema's name in the definition of the object.