If you insert records directly into the tables in mysql, then they only
have the rights you specifically specify. GRANT is smart enough to
handle a lot of the dirty-work for you. In particular, I like the:
GRANT SELECT on *.* to readonly@'%' identified by 'readonly';
This will create the user
umn level.
The output of SHOW GRANTS means that 'usernew' has no global
privileges (USAGE) and has SELECT privilege on the database 'Liste_MP3'.
C> Thanks!
C> -Original Message-
C> From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
C> Sent: 1 août, 2002
on 8/1/02 11:32 AM, Victoria Reznichenko at [EMAIL PROTECTED]
wrote:
> 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
>
27; |
| 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
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> +---
