List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:August 21 2002 1:34pm
Subject:Re: Privileges and Access Control
View as plain text  
You seem to havew a leading space in your newuser account.

Juri Nysschen wrote:

>Hi
>
>I have a problem with privileges on MySql NT 3.23.52. I hope that someone
>can provide me with a solution.
>
>If a user has USAGE privileges on the mysql db (*.*), and ALL privileges on
>another db (CUSTOMDB) in the system, that user can't login nor can they
>access the CUSTOMDB. The error reported is: "you have no access to database
>CUSTOMDB". Yet, according to the documentation, this user setup is valid.
>
>The Sql Statements are:
>GRANT USAGE  on *.* to newuser identified by password 'mypassword'
>GRANT ALL on CUSTOMDB to newuser
>FLUSH PRIVILIGES
>
>SHOW GRANTS for newuser
>Returns:
>GRANT USAGE ON *.* TO ' newuser'@'%'
>GRANT ALL PRIVILIGES ON CUSTOMDB.* TO ' newuser'@'%'
>
>The purpose of this user setup is to prevent access to the mysql.user table,
>should the login be compromised.
>
>Juri Nysschen
>
>The Digital Message Network (Pty) Ltd
>Tel. +27.(0)11.4750300
>Fax. +27.(0)11.4056300
>Http://www.dmnet.co.za
>
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread117727@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


Thread
Privileges and Access ControlJuri Nysschen21 Aug
  • Re: Privileges and Access ControlGerald Clark21 Aug