Greetings...

I want to create a user which will have only Select privileges in two
columns a particular table.

For that I creates a entry in the User table in MySQL and set it as default
with N in all.

Also I entered some rows in the Columns_Priv table. Now my question is -

Do I have to enter records in db and tables_priv table with the user name
and all privileges set to N or default to make the column privileges work or
if I enter a row in the columns_priv table, that will do.

Rgds
Insane

SQLyog ( http://www.webyog.com/sqlyog )
The Definative Front End for MySQL




---------------------------------------------------------------------
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

Reply via email to