Re: ACL issue
Date: Fri, 10 Jan 2014 15:36:05 -0700
Message-ID: <CAJzM94D=Bruvn1zSqC10dnbY+i7R95g0sBBw8zKbQ4WUMMasfw_at_mail.gmail.com>
Thanks everyone for your suggestions. Turns out the change was made 4 months ago, but that particular feature wasn't used until the end of the year so no one realized it was broken.
Sandy
On Thu, Jan 2, 2014 at 1:57 PM, Sandra Becker <sbecker6925_at_gmail.com> wrote:
> Only one ACL disappeared. One user's privilege was missing on another.
> None of our ACLs have expiration dates. Good thought though.
>
> Sandy
>
> On Thu, Jan 2, 2014 at 7:01 AM, rjamya <rjamya_at_gmail.com> wrote:
>
>> Sandra
>>
>> Happy New Year 2014.
>>
>> I was just curious if those ACLs had expiry date associated for all of
>> them to be disabled en-mass.
>>
>> Raj
>>
>>
>> On Mon, Dec 30, 2013 at 11:14 AM, Sandra Becker <sbecker6925_at_gmail.com>wrote:
>>
>>> Oracle: 11gR2 EE
>>> OS: SunOS 5.10 Generic_148888-01 (64 bit)<http://ptcgrid.ghx.com:4889/em/console/ecm/track/hc/view/osGeneral$target=pcntrcts.ghx.com$type=host?event=doLoad>
>>>
>>> Access control lists were set up in several production and
>>> non-production databases about 4 years ago. Certain scheduled jobs use
>>> UTL_SMTP. They have been working successfully since they were set up.
>>> This morning at 4:00am, two databases began failing when trying to email.
>>> The other 50+ databases continues working correctly.
>>>
>>> While troubleshooting the issue, I noticed that the privilege for the
>>> specific user was no longer there in the non-production database and the
>>> acl was missing from the production database. I re-granted the privilege
>>> in the non-production database and the job completed successfully. I had
>>> to re-create the acl, assign the host, and grant the privilege to the
>>> specific user in the production database and the jobs began executing
>>> successfully again.
>>>
>>> Questions:
>>> 1) What would cause this behavior? I have been the on-call DBA since
>>> Dec 25th and haven't even looked at these databases until I was paged this
>>> morning.
>>>
>>> 2) Is this common? Is this something we should be checking for? I've
>>> been here only 4 months and the lead DBA isn't sure what might have been
>>> the root cause.
>>>
>>> Any suggestions are appreciated. Thank you.
>>>
>>> Sandy
>>>
>>>
>>> --
>>> Sandy
>>> Transzap, Inc.
>>>
>>
>>
>
>
> --
> Sandy
> Transzap, Inc.
>
-- Sandy Transzap, Inc. -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 10 2014 - 23:36:05 CET