[user32489318]

I guess he meant to create a view of a table with “where” conditions depend on your user privileges

[bawolff]

Yes, using the DEFINER clause.

For all i know there could be other methods in mysql at this point, but views is how people have been doing fine grained row permissions in mysql for decades.