Add User -- Overview

Use the Add User notebook to authorize a user to use a database and the objects in it.

Tasks

• Defining a new database user to DB2
• Granting database authorities to a new user
• Granting schema privileges to a new user
• Granting table privileges to a new user
• Granting the CONTROL privilege on indexes to a new user
• Granting view privileges to a new user
• Granting the USE privilege on table spaces to a new user

Page controls

• Database
• Schema
• Table
• Index
• View
• Table Space

Fields and controls

• OK
• Cancel
• Apply
• Reset

Related information

• Controlling database access -- See the Administration Guide
• GRANT and REVOKE statements -- See the SQL Reference
• Authorizations and authorization names for users and groups