John-
GRANT privilege ON table_or_database_name TO [EMAIL PROTECTED] IDENTIFIED BY 'password'
in this case you need to
GRANT GRANT ON table_or_database_name TO [EMAIL PROTECTED] IDENTIFIED BY 'password'
Hope this helps,
Martin Gainty SQL Consultant USA 001-617-852-7822
From: "John R. Porter" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Problem with GRANT...WITH GRANT OPTION
Date: Wed, 21 Jul 2004 14:54:10 +0100
MIME-Version: 1.0
Received: from lists.mysql.com ([213.136.52.31]) by mc2-f16.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Wed, 21 Jul 2004 06:56:43 -0700
Received: (qmail 30011 invoked by uid 109); 21 Jul 2004 13:54:17 -0000
Received: (qmail 29991 invoked from network); 21 Jul 2004 13:54:17 -0000
Received: pass (lists.mysql.com: local policy)
X-Message-Info: JGTYoYF78jHJ0WhRVXWZU4HTCZz6ybBU
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
List-ID: <mysql.mysql.com>
Precedence: bulk
List-Help: <mailto:[EMAIL PROTECTED]>
List-Unsubscribe: <mailto:[EMAIL PROTECTED]>
List-Post: <mailto:[EMAIL PROTECTED]>
List-Archive: http://lists.mysql.com/mysql/169422
Delivered-To: mailing list [EMAIL PROTECTED]
Message-ID: <[EMAIL PROTECTED]>
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook CWS, Build 9.0.6604 (9.0.2911.0)
In-Reply-To: <[EMAIL PROTECTED]>
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Strath-Information: Contact <[EMAIL PROTECTED]> for more information
X-Strath-Scan: clean
X-Strath-UBECheck: X-Virus-Checked: Checked
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 21 Jul 2004 13:56:43.0725 (UTC) FILETIME=[8E23FFD0:01C46F2A]
I created a new user with a GRANT statement like:
GRANT SELECT, INSERT, UPDATE, DELETE ON test.* TO 'demouser'@'localhost' IDENTIFIED BY 'testpwd' WITH GRANT OPTION
If I then log in as 'demouser' I can execute SELECT etc. statements on the 'test' database, but if I try to create another user with access to 'test' using:
GRANT Select ON test.* TO 'newuser'@'localhost' IDENTIFIED BY 'newpwd'
I get:
Error: 1044 - Access denied for user: '[EMAIL PROTECTED]' to database 'mysql'
Does 'demouser' have to be explicitly GRANTed access to the MySQL grant
tables (user, db, host, tables_priv and columns_priv) before the user can be
GRANTed GRANT privileges to any database or table? If so, what are the
minimum privileges required?
John R. Porter I.T. Services University of Strathclyde Faculty of Education 76 Southbrae Drive Glasgow G13 1PP e-mail: [EMAIL PROTECTED] Tel. 0141 950 3289
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
