RE: DBA granted to app schema
From: Rich J <rjoralist3_at_society.servebeer.com>
Date: Thu, 14 Jul 2016 08:31:15 -0500
Message-ID: <e856deca4b5f7bb8710995cd276a4dae_at_society.servebeer.com>
Date: Thu, 14 Jul 2016 08:31:15 -0500
Message-ID: <e856deca4b5f7bb8710995cd276a4dae_at_society.servebeer.com>
On 2016/07/14 07:54, Dimensional DBA wrote:
I'm going through something similar right now, although I was able to talk the vendor out of the DML "ANY" privs. Instead of installing their schema into our ERP DB, I have an auxiliary DB that connects to the ERP DB via links. I created schemas to mirror the ERP DB, then views over the DB links. The vendor keeps warning of performance problems of the DB links, as though their views than generate 70-line explain plans aren't the real issue...
Not that this method will work for every vendor's software, but it might be one alternative.
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 14 2016 - 15:31:15 CEST