[閒聊] DB 誤刪了服務的使用者密碼怎麼辦
強者我朋友今天說了一個歷史悠久的鄉野奇談,姑妄言之姑聽之。
很久很久以前,有人不小心下錯 sql ,大概是類似這樣
update users set password = pass('test')
但忘了上 where ,所以就所有人密碼被改。
到這裡我們以為解決方案一定是撈備份,但想當然爾早期根本很多人沒這習慣,
就....悲劇。
下一招一定是叫使用者回來確認密碼~~但這樣就會被發現有人幹蠢事了。
最後他們想了一個招解決這個問題:
使用者打第一次密碼時回應使用者輸入錯誤,但偷偷把這密碼更新成正式密碼,
使用者第二次打密碼時就用剛剛的密碼去比對....
聽說好像後來只有很少的使用者有抓包這件事情 XDDDDDDDD
by 不可思議事件之好孩子不要學之民明書房
FB 好友表示......XDDD
https://www.facebook.com/tonylovejava/posts/10202918985041326
--
資訊界很有些聽起來很恐怖,但卻又是聽得出來其背後血淚/真實性的(鬼)故事啊。 XD
人家是聊齋誌異,這是聊齋"資"異。
--
Life's a struggle but beautiful.
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 118.166.93.88
※ 編輯: TonyQ 來自: 118.166.93.88 (12/20 16:12)
推
12/20 16:23, , 1F
12/20 16:23, 1F
→
12/20 16:24, , 2F
12/20 16:24, 2F
推
12/20 16:43, , 3F
12/20 16:43, 3F
→
12/20 16:44, , 4F
12/20 16:44, 4F
→
12/20 16:45, , 5F
12/20 16:45, 5F
→
12/20 16:46, , 6F
12/20 16:46, 6F
→
12/20 16:46, , 7F
12/20 16:46, 7F
→
12/20 16:47, , 8F
12/20 16:47, 8F
→
12/20 16:47, , 9F
12/20 16:47, 9F
→
12/20 16:48, , 10F
12/20 16:48, 10F
→
12/20 16:48, , 11F
12/20 16:48, 11F
推
12/20 16:58, , 12F
12/20 16:58, 12F
→
12/20 17:02, , 13F
12/20 17:02, 13F
→
12/20 17:04, , 14F
12/20 17:04, 14F
→
12/20 17:04, , 15F
12/20 17:04, 15F
→
12/20 17:04, , 16F
12/20 17:04, 16F
推
12/20 17:12, , 17F
12/20 17:12, 17F
→
12/20 17:14, , 18F
12/20 17:14, 18F
→
12/20 17:24, , 19F
12/20 17:24, 19F
推
12/20 17:37, , 20F
12/20 17:37, 20F
推
12/20 17:55, , 21F
12/20 17:55, 21F
→
12/20 17:56, , 22F
12/20 17:56, 22F
→
12/20 17:57, , 23F
12/20 17:57, 23F
→
12/20 17:58, , 24F
12/20 17:58, 24F
推
12/20 18:00, , 25F
12/20 18:00, 25F
推
12/20 18:01, , 26F
12/20 18:01, 26F
推
12/20 18:11, , 27F
12/20 18:11, 27F
推
12/20 18:19, , 28F
12/20 18:19, 28F
推
12/20 18:22, , 29F
12/20 18:22, 29F
推
12/20 18:30, , 30F
12/20 18:30, 30F
推
12/20 18:36, , 31F
12/20 18:36, 31F
→
12/20 18:39, , 32F
12/20 18:39, 32F
推
12/20 18:41, , 33F
12/20 18:41, 33F
→
12/20 18:41, , 34F
12/20 18:41, 34F
→
12/20 18:42, , 35F
12/20 18:42, 35F
→
12/20 18:44, , 36F
12/20 18:44, 36F
→
12/20 18:44, , 37F
12/20 18:44, 37F
→
12/20 18:50, , 38F
12/20 18:50, 38F
推
12/20 18:53, , 39F
12/20 18:53, 39F
還有 42 則推文
→
12/21 09:57, , 82F
12/21 09:57, 82F
→
12/21 09:59, , 83F
12/21 09:59, 83F
→
12/21 10:00, , 84F
12/21 10:00, 84F
→
12/21 10:02, , 85F
12/21 10:02, 85F
→
12/21 11:07, , 86F
12/21 11:07, 86F
→
12/21 11:07, , 87F
12/21 11:07, 87F
→
12/21 11:08, , 88F
12/21 11:08, 88F
→
12/21 11:08, , 89F
12/21 11:08, 89F
→
12/21 11:09, , 90F
12/21 11:09, 90F
→
12/21 11:11, , 91F
12/21 11:11, 91F
→
12/21 11:12, , 92F
12/21 11:12, 92F
→
12/21 11:13, , 93F
12/21 11:13, 93F
→
12/21 11:15, , 94F
12/21 11:15, 94F
→
12/21 11:17, , 95F
12/21 11:17, 95F
推
12/21 11:18, , 96F
12/21 11:18, 96F
→
12/21 11:18, , 97F
12/21 11:18, 97F
→
12/21 11:19, , 98F
12/21 11:19, 98F
→
12/21 11:20, , 99F
12/21 11:20, 99F
→
12/21 11:21, , 100F
12/21 11:21, 100F
→
12/21 11:22, , 101F
12/21 11:22, 101F
→
12/21 11:23, , 102F
12/21 11:23, 102F
→
12/21 11:24, , 103F
12/21 11:24, 103F
推
12/21 11:53, , 104F
12/21 11:53, 104F
推
12/21 14:36, , 105F
12/21 14:36, 105F
→
12/21 14:36, , 106F
12/21 14:36, 106F
→
12/21 23:44, , 107F
12/21 23:44, 107F
→
12/21 23:45, , 108F
12/21 23:45, 108F
→
12/21 23:46, , 109F
12/21 23:46, 109F
→
12/21 23:47, , 110F
12/21 23:47, 110F
→
12/21 23:48, , 111F
12/21 23:48, 111F
推
12/22 00:54, , 112F
12/22 00:54, 112F
推
12/23 14:02, , 113F
12/23 14:02, 113F
→
12/23 14:02, , 114F
12/23 14:02, 114F
→
12/23 14:03, , 115F
12/23 14:03, 115F
→
12/23 14:05, , 116F
12/23 14:05, 116F
→
12/23 14:06, , 117F
12/23 14:06, 117F
推
12/23 14:09, , 118F
12/23 14:09, 118F
→
12/23 22:12, , 119F
12/23 22:12, 119F
→
12/23 22:13, , 120F
12/23 22:13, 120F
→
12/23 22:14, , 121F
12/23 22:14, 121F