# Return MySQL user privileges

This function lists a MySQL® database user's privileges.



When you disable the MySQL role
and remote MySQL is not already configured, the system disables this function.

Endpoint: GET /Mysql/get_privileges_on_database
Version: 11.134.0.5
Security: BasicAuth

## Query parameters:

  - `database` (string, required)
    The database name.
    Example: "mydb"

  - `user` (string, required)
    The database user's name.



If database prefixing is enabled, you  prefix this value with the account prefix and an underscore ().

For example, for the  user on the  cPanel account, pass in a value of .
    Example: "dbuser"

## Response 200 fields (application/json):

  - `apiversion` (integer)
    The version of the API.
    Example: 3

  - `func` (string)
    The name of the method called.
    Example: "get_privileges_on_database"

  - `module` (string)
    The name of the module called.
    Example: "Mysql"

  - `result` (object)

  - `result.data` (array)
    An array of privileges.



If the database user does not have privileges on the database database,
this array will return empty.
* 
* One or more of the following individual privileges:
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  *
    Example: ["CREATE"]

  - `result.errors` (array,null)
    List of errors if the API failed.

  - `result.messages` (array,null)
    List of messages generated by the API.

  - `result.metadata` (object)

  - `result.metadata.transformed` (integer)
    Post-processing may have transformed the data.
    Enum: 1

  - `result.status` (integer)
    *  - Success
*  - Failed: Check the errors field for more details.
    Enum: 0, 1

  - `result.warnings` (array,null)
    List of warnings generated by the API.
Warnings describe non-critical failures or other problematic conditions noted while running a API.