Online Documentation for SQL Manager for DB2

Creating/editing user


Use the Property tab of User Editor to create/edit a user and specify its definition.

 

User Editor - Editing user definition

 

 

These options allow you to define common database privileges that can be granted to the user. Select/deselect the options to grant/revoke the corresponding privileges.

 

Grant...

 

CheckBox Database administrator authority

Grants database administrator authority and all other database authorities except for security administrator authority to the user.

 

CheckBox Authority to access the database

Enable this option to allow the user to connect to the database.

 

CheckBox Authority to create database tables

Enable this option to allow the user to create tables in the database. The user also gains the CONTROL privilege on the tables he creates.

 

CheckBox Authority to implicitly create schemas

Enable this option to automatically create a schema when the user creates a table specifying a non-existing schema.

 

CheckBox Authority to create packages

Enable this option to allow the user to create packages in the database. The user also gains the CONTROL privilege on the packages he creates.

 

CheckBox Authority to register routines which are executed in the database manager

Enable this option to allow the user to register routines that execute in the database manager's process. Care must be taken that routines so registered will not have adverse side effects.

 

CheckBox Authority to use the LOAD utility

Enable this option to allow the user to use LOAD utility.

 

CheckBox Authority to register external routines

Enable the option to allow the user to register external routines. Care must be taken that routines so registered will not have adverse side effects.

 

CheckBox Authority to access the database while it is quiesced

Enable this option to allow the user to access the database while it is in quiesced mode.

 

CheckBox Authority to grant and revoke all object level privileges and some of DB level privileges

Enable the option to grant the user access control authority. This authority can't be granted to PUBLIC. Server version 9.7 required.

 

CheckBox Authority to access data

Enable this option to allow the user to select, insert, update, delete, and load data, to execute any package or routine (except audit routines). This authority can't be granted to PUBLIC. Server version 9.7 required.

 

CheckBox Authority to explain statements

This authority allows the user to explain, prepare, and describe dynamic and static SQL statements without requiring access to data. Server version 9.7 required.

 

CheckBox Authority to manage SQL statement execution

Enable the option to allow the user to create, drop, flush, and set event monitors; to explain, prepare, and describe dynamic and static SQL statements without requiring access to data; to flush optimization profile and package cache; to execute the runstats utility.

 

CheckBox Security administrator authority

Enable the option to grant the user the security administrator authority. Server version 9.5 required.

 

CheckBox Authority to manage workloads

Enable this option to allow the user to manage workloads. Server version 9.7 required.