August 13th, 2000, 03:27 PM
Does anyone know how column privileges in mysql are set up?
I have a table called person(firstname,secondname,adress,zip)
A user called bar should only see the columns firstname and secondname, not adress and zip. If he writes:
select * from person
The query should return firstname,secondname.
I think it has something to do with the table called columns_priv in the database called mysql. Please help me!!!!
August 14th, 2000, 03:39 AM
PLEASE HELP ME!!! I am lost!!!