n R. Porter [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 21, 2004 11:09 AM
> To: [EMAIL PROTECTED]
> Subject: RE: Problem with GRANT...WITH GRANT OPTION
>
> 'GRANT GRANT ON table_or_database_name ...' gave a syntax error.
> 'GRANT GRANT OPTION ON table_or_da
nt tables, and if so, what are the minimum privileges
required?
Regards,
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
-Original Message-
From: aman [mailto:[EMAIL PROTECTED]
S
t; 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
rom: "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.2
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
