Convert End User To Analyst

Version 2

    Question


    Convert End User To Analyst

    Answer


    --Always fully test any scripts on a test environment and take a full backup before applying to live. --If you have already deleted these users in Console, tps_deleted will be set to 1. Change this to 0 to undelete select * from tps_user where tps_name in('John Smith', 'Fred Jones') --Change the users from 'End User' to 'Analyst' class. update tps_user set tps_user_type_guid =(select tps_guid from tps_user_type where tps_name = 'Analyst') where tps_guid in(select tps_guid from tps_user where tps_name in('John Smith', 'Fred Jones')) --Insert GUID values for the above user(s) so that they are recognised as Analysts within 'Administration' insert into tps_analyst(tps_guid) select tps_guid from tps_user where tps_name in('John Smith', 'Fred Jones') --change the licence type the user is using. update tps_user set tps_user_licence_type_guid = (select tps_guid from tps_user_licence_type where tps_name = 'Analyst') where tps_name in ('John Smith', 'Fred Jones')

    Environment


    ITBM

    Attachment(s)



    HDCRW81003_CallNotes and Descriptions.doc