Hi,

I am bit confused with the permission at table and column level. I would be greatfull if someone can help me out in this.

I have two database mysql, and mydb. mysql contains the default tables and mydb contains all the tables I use for my application.

I have 3 types of users for my application. 1) Genral User. 2) Staff, 3) Operator.

I want the set permissions for "Genral User" in such a way that it can only a) Select a give list of tables, b) Insert into a perticular table, c) denie access to all other tables in the database.

I have set the select permission and is working fine. But not able to set permission to denie access to any table.

I am user MySQL 3.23 on Win2K

regards

Rajeev