Field Level Security

[technologika]

I have a database with a users and users level table. I want to lock or make not visible certain fields based on the CurrentUser(). For example user john.doe is assigned user level 3 and has permission to edit information on fields a through c but not fields d through g. Can someone point me in the right direction? Thanks

[jforbes]

This is one way to go about what you are asking about:
SQL to Update User Password