Granting access in your program for users

[steve_rm]

Hello,

I have a program that when a user logs in they will only be able to do certain things based on there user privilege. Example, low, medium, and full access.

If the user has low then they can only view, if the use has medium they can edit and add, if they have full then they can do everything.

The buttons will be disabled for actions that they cannot do.

In the database, i have entered their privileges as low, med, or full.

I am not sure if this is the best way to do this, but before each form is loaded, i check there privileges by quering the database. Then disabling button based on their user privilege.

As this is my first time i have done this, I would like to know how this is done in the real world. Is there is a more efficient method of doing this.

Many thanks in advance,