1 Reply Latest reply on Nov 27, 2009 2:04 AM by Lara Hellman

    Error when trying to restore a soft delete user in sql query


      Thank you for your help CALVIN


      Contacting Server.
      Logging on to Server...
      Logged on.
      Loading Common Resources...
      Starting Console...

      Response from Services

      Authorisation failure. User is not authorised to perform Read operations on the Metadata.QueryTemplate class type.


      The above error occurs after the below given query is run


      update tps_user set tps_deleted = '0' where tps_name = 'testuser'

      update tps_password set tps_deleted = '0' where tps_guid = (select tps_password_id from tps_user where tps_name = 'testuser')


      Please can you help me with this ?