I want to implement privileges in phpmyadmin, at table level. I want certain columns only to be shown to the user. 

Here is the query I used.

```
REVOKE ALL PRIVILEGES ON `resource_test`.`resources` FROM 'test_user'@'%';

GRANT SELECT (`resource_id`, `first_name`) ON `resource_test`.`resources` TO 'test_user'@'%'WITH GRANT OPTION;

```

But I am unable to select only selected fields/columns.

Is it possible to only show the user a few number of columns only?

For your information i m using MySQL - 5.1.50