Mega Code Archive

 

Categories / MySQL Tutorial / Data Dictionary

 

MySQL permissions are stored in corresponding tables

columns_priv column privileges within a table dbprivileges for the databases funcprivileges for functions hostprivileges for the hosts tables_privindividual column privileges for a table userprivileges for the access by users In each table privileges for uses are set by 'Y' or 'N' in the appropriate column for a privilege. mysql> mysql> SELECT Host, Db, User, Select_priv     -> FROM db WHERE (DB = "test"); mysql>