List of Action Restrictions (SQL Statement)

The following SQL statement can be used to return a list of all action restrictions.

SELECT

MM405_USER_NAME
Role_Desc
,MM923_ROLE_ID
Role_ID
,MM030_OBJECT_ID
Obj_ID
,MM030_OBJECT_DESC
Obj_Desc
,MM923_TOOLBAR_BUTTON_ID
Button_ID
,MM040_BUTTON_NAME
Button_Name

FROM MM923_ACTION_RESTRICTIONS
JOIN MM030_OBJECT_MASTER
ON MM030_OBJECT_ID = MM923_OBJECT_ID
JOIN MM040_TOOLBAR_BUTTON_MASTER
ON MM040_TOOLBAR_BUTTON_ID = MM923_TOOLBAR_BUTTON_ID
JOIN MM405_USER_MASTER_EXT
ON MM405_USER_ID = MM923_ROLE_ID
ORDER BY
Role_Desc ASC
, Button_Name ASC

*Content contributed by Tickett Enterprises Limited