I will do that.
Regards..
From: Paul DuBois <[EMAIL PROTECTED]> To: "Miguel Perez" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] Subject: Re: GRANTs Options Date: Thu, 19 Jun 2003 18:57:15 -0500
At 18:47 -0500 6/19/03, Miguel Perez wrote:Hi everyone:
I wonder if the command GRANT could be alered. I mean if I have the following privileges over certain database:
+------------------------------------------------------------------------------------------+
| Grants for [EMAIL PROTECTED] |
+------------------------------------------------------------------------------------------+
| GRANT USAGE ON test.* TO 'olap'@'%' IDENTIFIED BY PASSWORD 'helloworld' |
| GRANT SELECT, INSERT, DELETE ON products.* TO 'olap'@'%' |
+------------------------------------------------------------------------------------------+
And I would like to change the privileges over the database test and then give privileges for the database products.
Is there a way to do that?. I just want to take off the privileges from the database test and give new permission to the database products.
In what way do you want the GRANT statement to be altered? Use REVOKE to remove the USAGE privilege on test:
REVOKE USAGE ON test.* FROM 'olap'@'%';
Then use GRANT to add the privileges that you want to add to the products database.
Thnx.
Greetings everyone
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
_________________________________________________________________
Únete al mayor servicio mundial de correo electrónico: http://www.hotmail.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]