Table and view level

  CONTROL privilege

  SELECT privilege

  INSERT privilege

  UPDATE privilege

  DELETE privilege

  INDEX privilege

  ALTER privilege

  REFERENCES privilege

Other privileges

  Package privileges

  Index privileges

  Procedure, function and method privileges

  Sequence privileges

Privileges can be granted to users or groups with the 

GRANT

 command, they can 

be revoked using the 

REVOKE 

command.

When a database is created, the following privileges are automatically granted to 

PUBLIC (all users): 

CREATETAB 

BINDADD 

CONNECT 

IMPLICIT_SCHEMA 

USE privilege on USERSPACE1 table space 

SELECT privilege on the system catalog views.

Mapping the user information from MySQL to DB2 UDB

When migrating from MySQL to DB2 UDB, you have to migrate the privileges of 

the users as well.

Table 6 1 shows the mapping from MySQL privileges to DB2 privileges, 

assuming that different MySQL 

databases

 are mapped to different DB2 

schemas

.

For example, an INSERT privilege granted in MySQL on the 

global

 level means 

that you have to grant the INSERT privilege on all existing tables in the DB2 

database to the specified user. If you create a new table in DB2 UDB, you have 

to grant the INSERT privilege on this table to the user.

144 

MySQL to DB2 UDB Conversion Guide