Project:
View Revisions: Issue #32354 | [ All Revisions ] [ Back to Issue ] | ||
Summary | 0032354: field edit access doesn't allow to save if tab contains audit fields in its AD definition | ||
Revision | 2016-02-26 08:54 by alostale | ||
Description | If a role has editable access to some fields in a tab that includes updated/updated by fields and in the editable permissions these fields are not included, when trying to edited any of the granted fields, an error message is seen and the operation is rolled back. Though these fields are not required to be included in the tab because they are always automatically included, it is not prevented and, in fact, there are some windows tabs that include them [1]. Checking those fields if any other is editable, has no sense because they are always updated in any edition. --- [1] There are 25 tabs in this situation: select w.name window_name, t.name tab_name from ad_column c, ad_field f, ad_tab t, ad_window w where (columnname ilike 'created' or columnname ilike 'updated') and f.ad_column_id = c.ad_column_id and f.isactive='Y' and t.ad_tab_id = f.ad_tab_id and t.isactive='Y' and t.ad_window_id = w.ad_window_id and w.isactive='Y' order by 1,2 |
||
Revision | 2016-02-26 08:53 by alostale | ||
Description | If a role has editable access to some fields in a tab that includes updated/updated by fields and in the editable permissions these fields are not included, when trying to edited any of the granted fields, an error message is seen and the operation is rolled back. Though these fields are not required to be included in the tab because they are always automatically included, it is not prevented and, in fact, there are some windows tabs that include them [1]. Checking those fields if any other is editable, has no sense because they are always updated in any edition. --- [1] There are 0000111:0000025 tabs in this situation: select w.name window_name, t.name tab_name from ad_column c, ad_field f, ad_tab t, ad_window w where (columnname ilike 'created' or columnname ilike 'updated') and f.ad_column_id = c.ad_column_id and f.isactive='Y' and t.ad_tab_id = f.ad_tab_id and t.isactive='Y' and t.ad_window_id = w.ad_window_id and w.isactive='Y' order by 1,2 |
Copyright © 2000 - 2009 MantisBT Group |