I used below command to grant select PRIVILEGES
on specific columns of a MySQL database table:
GRANT SELECT (p_id) ON DB_NAME.TABLE_NAME TO 'dbuser'@'localhost'
It is showing given PRIVILEGES
with SHOW GRANTS
command but when i login to phpMyAdmin with this user and try to select DB Table, it gives error
#1142 - SELECT command denied to user 'dbuser'@'localhost' for table 'my_users'
My select is:
SELECT * FROM `main_users`
How can I give select feature on specific columns of DB table?
7