MySQL Forums
Forum List  »  Security

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

Options: ReplyQuote


Subject
Views
Written By
Posted
restrict privileges variables
2874
October 22, 2005 03:30PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.