Dormant database user accounts

From: Leroy Kemnitz <lkemnitz_at_uwsa.edu>
Date: Thu, 12 Mar 2015 20:05:18 +0000
Message-ID: <BN3PR0701MB16372776F15AD113C5A32624B6060_at_BN3PR0701MB1637.namprd07.prod.outlook.com>



All -

We are currently having a discussion in house about user accounts in the databases that are considered 'dormant' or unused. I want to set a limit of one year. If after one year, the account has not been used at all, then I want to delete the account and send an email to the last known email address informing the customer. How do other places handle this situation? Do you lock the accounts and then notify customers - then delete if no response in 2 weeks? What time limits are other people using? I see some people are doing 90 days of not logging in flags an account as 'dormant'.

LeRoy

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 12 2015 - 21:05:18 CET

Original text of this message