Grant Permission Syntax/Qualifier for Column?

[Nic Plum]

It looks to be possible to set a permission on a column in a table.

If this is true, what is the syntax with respect to qualifying the name -
for a table it would be databasename.tablename but
databasename.tablename.columnname doesn't appear to work for a column?

Nic


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

grant permission

[Kaming]

Hi all,

Do anyone have this experience before?? I have granted the permission
for a machine to access mysql databases several times and then flush
privileges. I use perl DBI module to connect to databases through Web.
But I found that after a day or even several hours later. I found that
the apache log said that the DBI cannot connect to the mysql. It is
strange cause I can connect to the mysql from the mysql client of that
machine So I set another machine with the same configuration of
hardware, system and program setting and I found that this problem
didn't occur If anyone know about that. Can you please advise me
please. Many thanks.

Kaming.




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php