Create Read Only Columns
-
Is it possible to create columns that are read only to all roles other than the administrator role? The use case is as follows. There are three user roles, admin, instructor, and student. There is a table called evaluations. In the evaluations table there are 3 columns, the first column should be editable by student, the middle column should be editable by admin, and the last column should be editable by instructor. All columns and their data should be viewable by all, however. So, the instructor should be able to view the admin data and the student data with read only access, the student should be able to view the admin and instructor data with read only access. The admin could have edit access to all three columns or preferably only be able to edit the middle column. In my head it seems like the method I’ve outlined should work if there is functionality to do so, but if there is another option that I’m not considering to make this work, I’d appreciate that input also.
The topic ‘Create Read Only Columns’ is closed to new replies.