analyze_user_privileges
Analyze MySQL user privileges to identify excessive permissions or missing access rights across global, database, table, and column levels for security optimization.
Instructions
Analyze privileges for a specific user or all users.
Shows:
Global privileges
Database-level privileges
Table-level privileges
Column-level privileges
Routine privileges
Helps identify excessive or missing privileges.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| username | No | Username to analyze (omit for all users) | |
| hostname | No | Host pattern for the user | % |
Input Schema (JSON Schema)
{
"properties": {
"hostname": {
"default": "%",
"description": "Host pattern for the user",
"type": "string"
},
"username": {
"description": "Username to analyze (omit for all users)",
"type": "string"
}
},
"required": [],
"type": "object"
}