Re: Using views for access control. How?

[Oleksandr Byelkin]

I am not sure that I understand correctly what you want, but I answer on what I understand.

To get access to a view for SELECT/UPDATE/INSERT and so on (i.e. usual tables operation) you should use usual tables grants (a view is a table).

i.e.:

create view progect1_data as select * from data where data.project_id=1;
or
create view project1_data as select proj1_related_field1, proj1_related_field2, proj1_related_field3 from data;

grant SELECT on progect1_data to some_user@some_host;

Mr. Oleksandr Byelkin
MySQL AB, Full-Time Developer
Lugansk, Ukraine