Control field permissions and cell permissions in a datasheet

We used to have a few buttons on the page, control the permissions of these buttons, are all very skilled, such as btnadd Add button, Btnedit Edit button, btndelete Delete button, this page is the Student Basic information Management page Frmstudentmanager.

Then we can set the following permissions corresponding to the relationship:

The "addstudent" right corresponds to the available properties of the-> "Frmstudentmanager.btnadd" button

The "editstudent" right corresponds to the available properties of the-> "Frmstudentmanager.btnedit" button

The "deletestudent" right corresponds to the available properties of the-> "Frmstudentmanager.btndelete" button

This is well understood by everyone.

If the students this table has realname name, code number, age, sex Sex and other fields, users can access those columns also need permission control, we are very easy to confuse, in fact, is also very simple truth, but we do not thoroughly think the nature of the problem, In fact, we can set the following permissions corresponding to the relationship:

The "Viewstudentrealname" permission corresponds to the "Realname Name field is visible" in the-> list

The "Viewstudentcode" permission corresponds to the "Code number field is visible" in the-> list

The "Viewstudentage" permission corresponds to the "age-aged field visible" in the-> list

The "Viewstudentsex" permission corresponds to the "Sex sex field is visible" in the-> list

It's just a few more permissions, some of which are available for the corresponding button, and some of the corresponding columns are visible. The right control of the cell is also the same principle, you can extrapolate, just have the corresponding unique permissions corresponding to each cell.

In fact, the difficulty is not difficult, on the gap to pierce that layer of paper, the basic principle is the same, just changed a way of expression. In the past few years, often encountered, such a question, today's mood to write an article, for everyone to refer to the reference bar, may be sent to use later.

As for the database of all the tables, all the fields of automatic control, etc., that is another area of the problem, the above is only the core of the problem solving, you have a little flexibility, you can handle, and even the control of the data source, simply do not have the right to read the data even read out, it can also be based on the above ideas to solve, It depends on your own realization.

The privilege management, workflow management to the extreme of my ability, a person can only do so few of the few things