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






footer




 

 

 

 

 Home | About Us | Network | Services | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

san diego web hosting

 

Our partners: PHP: Hypertext Preprocessor Cheap Web Hosting JSP Web Hosting Ontario Web Hosting  Jsp Web Hosting

Cheapest Web Hosting Java Hosting Cheapest Hosting

Visionwebhosting.net Business web hosting division of Vision Web Hosting Inc.. All rights reserved