Script to change the Privileges for saving the Panel Layout Setting

Version 2

    Verified Product Versions

    LANDESK Service Desk 7.7.x

    Please ensure that the following actions are carried out outside of normal operating times and ensure a full backup of your database has been taken and verifed in advance of executing the script.

     

    Please run the following script to change the privileges for the Panel Layout Setting for ANALYSTS. You need to run this script if you want to give Analysts the ability to save any layout changes, as this privilege cannot be set within the user interface at the present time.

     

    If you would like to run this for any other role you would need to amend the script first.

     

     

    ----------------------------------------------------------------
    update tps_privilege set tps_value = 31
    where tps_item_guid = (select md_guid from md_privileged_item where md_name = 'system.usersetting')
    and tps_collection_guid = (select tps_privilege_collection_guid from tps_role where tps_name = 'analyst')

    update tps_privilege set tps_value = 31
    where tps_item_guid = (select md_guid from md_privileged_item where md_name = 'system.applicationconfiguration')
    and tps_collection_guid = (select tps_privilege_collection_guid from tps_role where tps_name = 'analyst')

    ----------------------------------------------------------------

     

    After the Script has been run, please perform an IISReset on server hosting TPS and restart Console.