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

    Rookie

      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 ?

       

      Alfy