Screens and Tabs › Tabs › Endpoint Account Management Tabs › Account Management Screens › IBM DB2 UDB › Account Tab

Account Tab

Use this tab to identify or specify user authorities granted, such as the authority to create tables, schemas or packages.

The fields in this tab are listed below:

Account ID

• Specifies the authorization ID.
• Rule String: %AC%

Exception Account

When checked, specifies that the account is an exception account.

*For Accounts Only

Database Authorities

Specifies the authorities granted to the account or account template. You can choose from the following:

Connect Database

Specifies authority to connect to the database that associates with the DB2 UDB endpoint.

Create Tables

Specifies authority to create tables that associates with the DB2 UDB endpoint.

Create Packages

Specifies authority to create packages that associates with the DB2 UDB endpoint.

Register Functions to Execute in Database Manager's Process

Specifies authority to register functions to execute in the database manager's process.

Database Administrator Authority

Specifies authority to connect to the database that associates with the DB2 UDB endpoint.

Create Schemas Implicitly

Specifies authority to create schemas implicitly that associates with the DB2 UDB endpoint.

Access to the Load Utility

Specifies authority to access the load utility that associates with the DB2 UDB endpoint.

To grant an authority, select one from the Available Values list box and click the right arrow (>) to move it into the Current Values list box. To grant all authorities, click the double right arrow (>>) to move all the authorities into the Current Values list box. To remove an authority, select the authority and click the left arrow (<) to move it back to the Available Values list box. To remove all authorities, click the double left arrow (<<).