Yes, but when I create a user with any other grants, it generates
automatically this "grant usage on *.*":
mysql> use Liste_MP3;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> grant select on Liste_MP3.* to usernew@localhost identified by
"password";
Query OK, 0 rows affected (0.01 sec)
mysql> show grants for usernew@localhost;
+---------------------------------------------------------------------------
----
--------+
| Grants for usernew@localhost
|
+---------------------------------------------------------------------------
----
--------+
| GRANT USAGE ON *.* TO 'usernew'@'localhost' IDENTIFIED BY PASSWORD
'0c2993b965
2e3c06' |
| GRANT SELECT ON Liste_MP3.* TO 'usernew'@'localhost'
|
+---------------------------------------------------------------------------
----
--------+
2 rows in set (0.00 sec)
It's a new user I never entered before, and still, it generates this usage
on *.*...
Thanks!
-----Original Message-----
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: 1 août, 2002 11:32
To: [EMAIL PROTECTED]
Subject: Re: permissions questions...
Caron,
Thursday, August 01, 2002, 5:34:16 PM, you wrote:
C> mysql> show grants for nouveau@localhost;
C>
+---------------------------------------------------------------------------
C> ------------+
C> | Grants for nouveau@localhost |
C>
+---------------------------------------------------------------------------
C> ------------+
C> | GRANT USAGE ON *.* TO 'nouveau'@'localhost' IDENTIFIED BY PASSWORD
C> '4be6641910d7bc1b' |
C>
+---------------------------------------------------------------------------
C> ------------+
C> 1 row in set (0.00 sec)
C> mysql> revoke usage on *.* from nouveau@localhost;
C> Query OK, 0 rows affected (0.00 sec)
C> Is there a way to get rid of that?
:-)
Yes, give to user 'nouveau' any privileges except USAGE.
USAGE is a synonim for 'no privileges'.
C> Is there a way to create a user by giving access to only one database,
C> without giving him the permission to "mysqlshow --user=[thisuser]
C> --password=[thispassword]" and retrieve all database names? He should see
C> only the name of his database...?
Yes, start mysqld with --safe-show-database option. And since 4.0.2
there is a SHOW DATABASES privilege.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
