How to Reset Team Calendar Subscription of a User

Still need help?

The Atlassian Community is here for you.

Ask the community

Problem

You are an administrator of Confluence and you want to remove all calendar subscriptions from a user.

Resolution

Please backup your database before making any of the changes below. Please note that this is not supported and it is only meant to be a guide.

In order to delete all calendar subscription of a single user:

  1. Shut down Confluence
  2. Find the user_key of the user by executing the SQL:

    SELECT * FROM user_mapping WHERE username = '<username>';

    Take note of the user_key column

  3. Execute the DELETE SQL query below. Replace CREATOR values with the user_key values obtained from step 2:

    DELETE FROM "AO_950DC3_TC_SUBCALS" WHERE "CREATOR" = '<user_key>' AND "SUBSCRIPTION_ID" IS NOT NULL;

    This will remove all subscriptions that the user have to other calendars other than the calendar that he created on his own.

  4. Start Confluence

Last modified on Jan 16, 2017

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.