SHOW GRANTS FOR [EMAIL PROTECTED];
It is important that the mix of username and hostname is the one which is
specified in the privilege database.
Please see the manual for details.
show grants for [EMAIL PROTECTED];
+----------------------------------------------------------------------------------------------------------------+
| Grants for [EMAIL PROTECTED]
|
+----------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root
|
+----------------------------------------------------------------------------------------------------------------+
1 row in set (0.09 sec)
Best regards
Nils Valentin
Tokyo/Japan
2003年 8月 25日 月曜日 21:[EMAIL PROTECTED] さんは書きました:
> Is there a way for a user to get knowledge about his own privileges?
> For example can a user know if he/she has rights to INSERT INTO some table?
> I'm using PHP4
--
---
Valentin Nils
Internet Technology
E-Mail: [EMAIL PROTECTED]
URL: http://www.knowd.co.jp
Personal URL: http://www.knowd.co.jp/staff/nils
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
