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.