Re: Dormant database user accounts

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Fri, 13 Mar 2015 10:06:18 -0500
Message-ID: <CAJvnOJYcZ5n1zCQt_4xpdbOoCGhvx_BnOL3ovgGWXhbquYkpRw_at_mail.gmail.com>



You need to be a little cautions about this. We have accounts that own objects that we never log in to. But the objects are critical.

On Thu, Mar 12, 2015 at 3:05 PM, Leroy Kemnitz <lkemnitz_at_uwsa.edu> wrote:

> 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
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 13 2015 - 16:06:18 CET

Original text of this message