Page 1 of 1
Giving normal users access to modify forms
Posted: Fri Jun 11, 2021 11:30 pm
by icoso
Is there a way to create a user that would have access to be able to modify a forms properties, such as the field properties that pop up when you double click the field name on a form? I want to give them the ability to modify the selection data on Select Fields.
Re: Giving normal users access to modify forms
Posted: Fri Jun 11, 2021 11:49 pm
by kev1n
To give a user access to the object properties form, execute this SQL. Replace 5fe2ceed176ce09 with the Acess Level Id of that user.
Code: Select all
INSERT INTO `zzzzsys_access_form` (`zzzzsys_access_form_id`, `slf_zzzzsys_access_id`, `slf_zzzzsys_form_id`, `slf_add_button`, `slf_save_button`, `slf_delete_button`, `slf_clone_button`, `slf_new_button`, `slf_print_button`, `slf_data_mode`) VALUES ('nuobject', '5fe2ceed176ce09', 'nuobject', '0', '1', '0', '0', NULL, '1', NULL)
Note: This would allow the user to modify all objects of all forms.
To allow a user to modify just one (select) object, create a new form where it can be modified.