Re: Dormant database user accounts
From: Marcos Colmenares H. <mcolmenares_at_newtechsistemas.com.ve>
Date: Fri, 13 Mar 2015 15:08:07 -0430
Message-ID: <CA+8yTWEAi=dv+KVHTRK6KgXBRG2BPoE89sLBkc4FK7C0ioHRbA_at_mail.gmail.com>
Im with mark on this one ... i would start sending emails about account closure .. then instead of deleting them i would change the passes for a month or two... once you change the pass people will either ask why its not working or its just not needed ...
Date: Fri, 13 Mar 2015 15:08:07 -0430
Message-ID: <CA+8yTWEAi=dv+KVHTRK6KgXBRG2BPoE89sLBkc4FK7C0ioHRbA_at_mail.gmail.com>
Im with mark on this one ... i would start sending emails about account closure .. then instead of deleting them i would change the passes for a month or two... once you change the pass people will either ask why its not working or its just not needed ...
i would also document all the actual account data (grants and the such) and keep it in a document just in case you need to re-create it.
Saludos Cordiales,
Marcos Colmenares H
-- 2015-03-13 14:52 GMT-04:30 Powell, Mark <mark.powell2_at_hp.com>:Received on Fri Mar 13 2015 - 20:38:07 CET
> If you are going to notify the user I think you should send the email X
> days prior to deleting the account.
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Andrew Kerber
> *Sent:* Friday, March 13, 2015 11:06 AM
> *To:* lkemnitz_at_uwsa.edu
> *Cc:* oracle-l_at_freelists.org
> *Subject:* Re: Dormant database user accounts
>
>
>
> 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