In Table PSAUTHITEM
AUTHORIZEDACTIONS Codes : the Authorized Actions
1: Add
2: Update Display
3: Add/Update/Display
4: Update/Display All
5: Add/Update/Display All
6: Update/Display/Update/Display All
7: Add/Update/Display/Update/Display All
8: Correction
9: Add/Correction
10: Update/Display / Correction
11: Add/Update/Display/Correction
12: Update/Display All/Correction
13: Add/Update/Display All/Correction
14: Update/Display/Update/Display All/Correction
15: Add/Update/Display/Update/Display All/Correction
128: Data Entry
For all the authorized actions for a given menu item for a given operator, these numbers are added together and stored in the authorizedactions column.
For example, if the value for authorizedactions column is 143, the operator is authorized for all the actions. (1+2+4+8+128) .
As another example, if the value is 7, the operator is authorized for the actions Add, Update/Display, Update/Display All (1+2+4).
1 comment:
Here is a SQL order for this information
select classid, MENUNAME, barname, baritemname, PNLITEMNAME, DISPLAYONLY,AUTHORIZEDACTIONS
,BITAND(AUTHORIZEDACTIONS,1) as add_
,BITAND(AUTHORIZEDACTIONS,2)/2 as update_display_
,BITAND(AUTHORIZEDACTIONS,4)/4 as update_display_all
,BITAND(AUTHORIZEDACTIONS,8)/8 as correction_
from PSAUTHITEM;
Post a Comment