List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:August 6 1999 1:33pm
Subject:[Q]Access privileges
View as plain text  
>>>>> "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
Thread
[Q]Access privilegesAndrey Kotrekhov6 Aug
  • [Q]Access privilegesMichael Widenius6 Aug