'Restrict A Row From Being Viewed by A User [duplicate]

I have a Table in MySQL dB but I'm trying to make a particular row (say phone numbers) from being seen by users without certain priviledge. Can anyone help me out on this?

mysqlprivileges


Solution 1:[1]

I'm assuming you mean column privelege instead of row. From the MySQL Reference Manual

Column Privileges

Column privileges apply to single columns in a given table. Each privilege to be granted at the column level must be followed by the column or columns, enclosed within parentheses.

GRANT SELECT (col1), INSERT (col1, col2) ON mydb.mytbl TO 'someuser'@'somehost';

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Christopher

Related Questions