User privileges for compatibility assessment

Before you use the compatibility assessment feature to evaluate database objects, ensure that a database user has been created for each data source and that the user has the required privileges.

Procedure

1. Log in to the MySQL database.

2. Run the following command to create a database user.

   CREATE USER '<user_name>' IDENTIFIED BY '<password>';
   

   Parameter	Description
   user_name	The name of the user to be created.
   password	The password of the user to be created.

3. Use the GRANT statement to grant privileges to the created database user.

   The compatibility assessment user must have SELECT privileges on the database to be assessed. The grant statement is as follows.

   GRANT SELECT ON <database_name>.* TO '<user_name>';
   

   Parameter	Description
   database_name	The name of the database to which SELECT privileges are granted.
   user_name	The name of the database user to which SELECT privileges are granted.

   If you select Profile Assessment as the assessment type when creating an online assessment task, you must also grant the user SELECT privileges on sys.*.

   GRANT SELECT ON sys.* TO '<user_name>';