GRANT SELECT ON *.* TO 'monty'@'%'

[gert cuykens]

Anybody knows how to grant a specific select statement in mysql ? For example user monty can only do select * from `table` where `user`='monty' ?

[mattyblah]

does mysql have views? you could create a view and grant them permission on that view...

[gert cuykens]

CREATE VIEW v AS select * from `table` where `user`='monty';

Perfect thanks :)