Privileges in MySQL can be granted on the following levels:

Global level

Global privileges are used on all databases on a given server and are stored 

in the 

mysql.user

 table.

Database level

Database privileges are used on all tables in a given database and are stored 

in the 

mysql.db

 (database privileges) and

 mysql.host 

(host privileges) tables.

Table level

Table privileges are used on all columns in a given table and are stored in the 

mysql.tables_priv

 table.

Column level

Column privileges are used on single columns in a given table and are stored 

in the 

mysql.columns_priv

 table.

Privileges can be granted to users with the MySQL 

GRANT 

command; they can be 

revoked with the 

REVOKE

 command.

The privilege for a specific command is determined like this:

global privileges

OR (

database privileges

 AND

 host privileges

)

OR 

table privileges

OR 

column privileges

To retrieve privilege information from a MySQL database, the

 mysqlaccess

 tool 

can be used.

For more information about MySQL privileges please, see the 

MySQL Reference 

Manual

.

DB2 security system

DB2 UDB has no separate user account management, it uses the user accounts 

from the operating system where the database is installed on and grants the 

users specific database privileges needed.

User data

Creating a user for DB2 UDB means to create a user in the server's operating 

system, assign the user to a group, and grant specific database privileges to the 

user or group.

On Linux systems you must have root access to the system to create groups and 

users. Group information is stored in the file 

/etc/group

, user information in the 

file 

/etc/passwd

.

140 

MySQL to DB2 UDB Conversion Guide