Table 6 1   Mapping of MySQL to DB2 privileges

MySQL

MySQL

DB2 privilege

DB2 scope

privilege

scope

or authority

Select

global

Select

All tables in the database

Insert

global

Insert

All tables in the database

Update

global

Update

All tables in the database

Delete

global

Delete

All tables in the database

Create

global

Createtab

Database

Drop

global

Dropin

All schemas

Reload

global

not available

Shutdown

global

 SYSADM, SYSCTRL, or 

Instance

SYSMAINT authority 

Process

global

 SYSADM, SYSCTRL, or 

Instance

SYSMAINT authority 

File

global

LOAD authority

Database

Grant

global

Control

All tables in the database

Index

global

Createin

All schemas

Alter

global

Alterin

All schemas

Show_db

global

Select

SYSCAT.TABLES

Super

global

not available

Create_tmp_

global

Createtab

Database

table

Lock_tables

global

Select

All tables in the database

Repl_slave

global

not available

Repl_client

global

not available

Select

database

Select

All tables in the schema

Insert

database

Insert

All tables in the schema

Update

database

Update

All tables in the schema

Delete

database

Delete

All tables in the schema

Create

database

Createin

Schema

 Chapter 6. Data porting 

145