2;U;Users within Database;Select distinct user from user where user <> '';User;1800;
10;O;Tables within Database;TABLE;Table;1800;Type;1000;Desc;3500;
20;U;Users within Database;Select distinct user from user where user <> '';User;1800;
30;C;Column list for;O;Column;2000;Type;1200;Length;650;Scale;500;Nulls;500;Desc;3000;
31;O;Primary key for;P;Column;2000;
32;M;Access list for;Select User, Table_priv, Grantor, Timestamp from tables_priv where Table_name = ?;Userid;1200;Privileges;2200;Grantor;1200;Timestamp;1500;
33;A;Table authorities for user;Select Table_Name, '', if(Table_priv REGEXP 'S','Y','N'), if(Table_priv REGEXP 'U','Y','N'), if(Table_priv REGEXP 'I','Y','N'), if(Table_priv REGEXP 'D','Y','N'), if(Table_priv REGEXP 'G','Y','N') from tables_priv where user = ? order by 1;Name;1800;Dummy;1;Select;700;UpDATE;700;Insert;700;Delete;700;Grant;700;
34;B;Access List for;Select Table_name, Table_priv, Grantor, Timestamp from tables_priv where User = ? order by 1;Table;1800;Privileges;2200;Grantor;1200;DATE;2000;
35;D;Contents of;xx;Name;1500;
36;S;Full details of user;select * from user where user=?;Column;1200;Value;2000;