Versions Compared

Old Version 5

changes.mady.by.user Amith Mathur

Saved on

compared with

New Version Current

changes.mady.by.user Melanie Corletto

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. List all reports owned by this user, the SQL example is the following:

    Code Block
    SELECT "ID", "NAME", "OWNER_ID" FROM "AO_6B9F04_AIO_REPORT" WHERE "OWNER_ID" = '<owner id for that user>';

  2. Update the owner for all the reports identified in the previous step. An example SQL query is below:

Code Block
UPDATE "AO_6B9F04_AIO_REPORT" SET "OWNER_ID" = '<new owner id>' WHERE "ID" = '<report id>';

  1. Update email subscriptions for all the reports with updated owners:

Code Block
UPDATE "AO_6B9F04_AIO_SCHED_REP_RCPT" SET "RECIPIENT_ID" = '<new owner id>' WHERE "RECIPIENT_ID" = '<old owner id>';
Info

  • Please note this is a workaround on a special situation, all measures should be taken to avoid direct changes to the database.

  • Currently we also have an improvement request for this purpose.