[santa_boy]

Curious, Is there an easy way to do row-level and field-level security in MySQL?

[fipar]

Field-level is just column privileges. Row-level, I think you can only achieve that with views, which is less than ideal.

[bawolff]

Views?

[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.