How to Reset Team Calendar Subscription of a User
You are an administrator of Confluence and you want to remove all calendar subscriptions from a user.
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:
- Shut down Confluence
user_keyof the user by executing the SQL:
SELECT * FROM user_mapping WHERE username = '<username>';
Take note of the
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.
- Start Confluence