Search code examples
mysqldatatableprivilegesdatabase-administrationuser-management

MySQLUser administration deny access

I like to deny the change and creating of tables for a specific users. So I searched for setting such privileges, but I've found nothing about it.

how can I archive these?

Solution

  • It is possible and you can find out more here: http://dev.mysql.com/doc/refman/5.7/en/account-management-sql.html. In MySQL these privileges are stored in the MySQL > table_privs table.