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.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]