audit-labs/audit-tools

A collection of scripts, queries, and other goodies you can use in an audit.

clone: git clone https://gitbay.org/audit-labs/audit-tools.git

v1.0.0: databases/mysql/mysql_admins_alt.sql · raw

 1-- Global Permissions
 2SELECT ... FROM mysql.user;
 3
 4-- Database Permissions
 5SELECT ... FROM mysql.db
 6WHERE db = @db_name;
 7
 8-- Table Permissions
 9SELECT ... FROM mysql.tables
10WHERE db = @db_name;
11
12-- Column Permissions
13SELECT ... FROM mysql.columns_priv
14WHERE db = @db_name;