[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_GRANTS.html
--
For technic
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];
+-
[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 General Mailing
