Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: vendor using oracle 10g database for application, but wants to lock access to data (vendor lock-in)

Re: vendor using oracle 10g database for application, but wants to lock access to data (vendor lock-in)

From: <bdbafh_at_gmail.com>
Date: 27 Jun 2005 22:46:45 -0700
Message-ID: <1119937605.321564.95690@g49g2000cwa.googlegroups.com>


Oskar,

Your employer's staff most certainly should have read only access to their data under the appropriate privilege scheme.

however, the application is supported by the app vendor. if you invalidate the vendor's support contract by modifying the data outside of their APIs (namely their app code) you risk a data corruption issue, loss of support and a rather large amount of grief. If you insist upon changing the data, extract the entire contents of the database (or clone the database) and muck with it there - and propagate those changes via their approved, official interfaces/APIs back into production - or not at all.

realize your place in the world - your employer bought the app for business reasons far more important that one (hotshot?) developer. If you are an incredibly good architect and can manage some developers - perhaps you should rewrite the app from scratch (better not have examined the vendor schema too closesly - think clean room).

read the contracts and don't put yourself in between a vendor ready to litigate and your higher ups that will have to cover their behinds.

One more word: HIPAA.

Adhoc changes to medical records is an auditor's worst nightmare.

-bdbafh Received on Tue Jun 28 2005 - 00:46:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US