MySQL

MySQL

DB2 privilege

DB2 scope

privilege

scope

or authority

Drop

database

Dropin

Schema

Grant

database

Control

All tables in the schema

Index

database

Creatin

Schema

Alter

database

Alterin

Schema

Create_tmp_

database

Createin

Schema

table

Lock_tables

database

Select

All tables in the schema

Select

table

Select

Table

Insert

table

Insert

Table

Update

table

Update

Table

Delete

table

Delete

Table

Create

table

not available

Drop

table

Control

Table

Grant

table

Control

Table

Index

table

Index

Table

Alter

table

Alter

Table

Select

column

Select

Table/view

Insert

column

Insert

Table/view

Update

column

Update

Table/view

Note:

 Privileges on the column level are not natively supported in DB2 UDB. 

The workaround for maintaining privileges on that scope is by defining views 

for specified columns in a table, and maintaining the privileges on table level 

of the view.

6.2  Sample project: Doing the data porting

This chapter describes the steps that we use to migrate the data in our sample 

project.

146 

MySQL to DB2 UDB Conversion Guide