Re: FLASHBACK ANY TABLE

From: Mark Burgess <mark_at_burgess-consulting.com.au>
Date: Thu, 19 Mar 2015 11:27:39 +1100
Message-Id: <4F88C6B7-B155-45BF-AFE1-C43895112DA7_at_burgess-consulting.com.au>



Kumar,

I can’t see any reason why you would want to give flashback table to the APPS schema - the potential for damage on the core eBS tables is too high. A flashback table on an eBS table would likely introduce major data integrity issues let alone support issues.

Perhaps flashback query is something that the developers are looking for?

Regards,

Mark

> On 18 Mar 2015, at 10:50 pm, Kumar Madduri <ksmadduri_at_gmail.com> wrote:
>
> Hello:
> Our developers have requested flashback any table to be given to apps (in an ebusiness environment). They would not have the apps password in production. I think they are using it to build some feature in a custom app.
> Regardless of their motivation, I think this is a security risk because why would a developer want this privilege in a production environment.
>
> I cant think like a hacker but it does not sound right to me.
> Want to confirm with the list if I am missing something ?
>
> Thank you
> Kumar

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 19 2015 - 01:27:39 CET

Original text of this message