[Q]Access privileges

[Michael Widenius]

>>>>> "Andrey" == Andrey Kotrekhov <kota@stripped> writes:

Andrey> Hello,All !
Andrey> I restrict user select from one field of table.
Andrey> But how this user know from what field user can get information?

Andrey> select * from this_table 

Andrey> It is wrong , user can't select from all fields.

Andrey> how user can get information about his permissions?


Hi!

Sorry, you can't do that with MySQL 3.22;  With MySQL 3.23 you can use 
SHOW COLUMNS FROM table_name to check the privileges.

Regards,
Monty