KarelWintersky revisó este gist . Ir a la revisión
1 file changed, 35 insertions
mysql_users.md(archivo creado)
| @@ -0,0 +1,35 @@ | |||
| 1 | + | # Подробный список всех привилегий для всех пользователей | |
| 2 | + | ||
| 3 | + | ```sql | |
| 4 | + | SELECT | |
| 5 | + | grantee, | |
| 6 | + | table_schema, | |
| 7 | + | privilege_type | |
| 8 | + | FROM | |
| 9 | + | information_schema.schema_privileges | |
| 10 | + | ORDER BY | |
| 11 | + | grantee, table_schema; | |
| 12 | + | ``` | |
| 13 | + | ||
| 14 | + | # Альтернативный вариант с объединением информации | |
| 15 | + | ```sql | |
| 16 | + | SELECT | |
| 17 | + | u.user, | |
| 18 | + | u.host, | |
| 19 | + | db.db, | |
| 20 | + | db.select_priv, | |
| 21 | + | db.insert_priv, | |
| 22 | + | db.update_priv, | |
| 23 | + | db.delete_priv, | |
| 24 | + | db.create_priv, | |
| 25 | + | db.drop_priv, | |
| 26 | + | db.grant_priv | |
| 27 | + | FROM | |
| 28 | + | mysql.user u | |
| 29 | + | LEFT JOIN | |
| 30 | + | mysql.db db ON u.user = db.user AND u.host = db.host | |
| 31 | + | WHERE | |
| 32 | + | db.db IS NOT NULL | |
| 33 | + | ORDER BY | |
| 34 | + | u.user, u.host, db.db; | |
| 35 | + | ``` | |
Siguiente
Anterior