restrict privileges variables
Posted by:
rm_mysql
Date: October 22, 2005 03:30PM
Hello,
is it possible to deny accessing the sytem variables and status variables to users?
Background:
I created an user without any Privileges.
Output from mysql.user table:
"%","testacco","32f7a418468d2bdd","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","N","","","","",0,0,0
Output from mysql.db table:
"%","mysql","testacco","N","N","N","N","N","N","N","N","N","N","N","N"
"%","rmtest","testacco","N","N","N","N","N","N","N","N","N","N","N","N"
But this user can see all the system and status variables using Mysql Administrator.
Is it possible to hide this variables?
Later, the user should have CREATE, INSERT, UPDATE, DELETE Privilegs but no access to any status and server variables
I'm using MySQL 4.1.14 on NetBSD.
Thank you.
Reinhold