[EMAIL PROTECTED] wrote:
>>User can use SHOW GRANTS command:
>
> Thank you!
> But one more question: what privileges user should have to issue this command? I've
> got a user who has rights only to SELECT from certain db. What should i GRANT to him
> to allow use of SHOW GRANTS?
>
Every user c
>User can use SHOW GRANTS command:
Thank you!
But one more question: what privileges user should have to issue this command? I've
got a user who has rights only to SELECT from certain db. What should i GRANT to him
to allow use of SHOW GRANTS?
--
MySQL General Mailing List
For list archives: ht
[EMAIL PROTECTED] wrote:
> 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
>
User can use SHOW GRANTS command:
http://www.mysql.com/doc/en/SHOW_GRAN
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.
[snip]
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
[/snip]
Of course! If they have access to a query on the mysql.user table they
can see their permissions.
--
MySQL Ge
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]