All Products
Search
Document Center

Why am I unable to view the information of certain databases and tables

Last Updated: Aug 06, 2020

Database Autonomy Service (DAS) offers storage management features. If you use the storage management features for ApsaraDB RDS for MySQL databases, certain databases or tables may fail to be displayed. The possible cause is that the database account that you authorize to DAS does not have the SELECT permissions on these databases or tables.

View permissions

  1. Run the following command to check whether a database account has the SELECT permissions on the corresponding databases and tables.
    In the following example, the name of the database account is das_test@’%’: show grants for das_test@'%';
    Based on the command output, check whether a database account has the SELECT permission on the corresponding databases and tables.

  2. You can also use the account management feature in the ApsaraDB for RDS console to check whether the database account has the SELECT permissions on the corresponding databases or tables.

Solutions

  1. If you have a privileged account, run the Grant command to grant the database account the SELECT permission. An example is described as follows:Grant Select on 'Database name'.* to das_test@'%';

  2. If you do not have a privileged account, use the account management feature in the ApsaraDB for RDS console to grant the database account the read-only permission.