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
Also, if you have any doubts whether your changes took the right effect,
check the mysql database on your server and check out the tables that
store privileges assigned by your GRANT query.
Aman Raheja
http://www.techquotes.com
On Wed, 2004-07-21 at 11:11, Martin Gainty wrote:
> John-
>
> GRANT
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"
