In the last episode (Jan 28), Nic Plum said: > 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?
>From the docs ( http://www.mysql.com/doc/G/R/GRANT.html ): GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...] ON {tbl_name | * | *.* | db_name.*} TO user_name [IDENTIFIED BY 'password'] [, user_name [IDENTIFIED BY 'password'] ...] [REQUIRE [{SSL| X509}] [CIPHER cipher [AND]] [ISSUER issuer [AND]] [SUBJECT subject]] [WITH GRANT OPTION] The only `priv_type' values you can specify for a column (that is, when you use a `column_list' clause) are `SELECT', `INSERT', and `UPDATE'. -- Dan Nelson [EMAIL PROTECTED] --------------------------------------------------------------------- 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
