Slashdot is powered by your submissions, so send in your scoop


Forgot your password?

Submission + - Customer wants to access my database - help!

cyteen02 writes: "We run a data processing and tracking system for a customer in the United Kingdom. We provide a simple website where the customer can display the tracking data held in our Oracle database. From these screens they can query based a combination of 15 different data fields, so it's pretty flexible. We also provide a csv report overnight of the previous day's data processing, which they can load into their own SQL Server database and produce whatever reports they want. Occasionally they also want one-off specific detailed reports, so we write the sql for that and send them the results in an excel format spreadsheet.

This all ticks along happily.

However they have now asked for direct read-only access to our Oracle database, to be able to run ad-hoc queries without consulting us.

As a DBA, my heart sinks at the thought of amateurs accessing my database. Unfortunately "because you are stupid" is not considered a valid business reason to reject their request. So can any Slashdotters assist me in building my case to restrict access? Have you experienced a similar situation? Have you had to support this sort of end user access? How would you advice me to keep my customer away from my precious tables?"
This discussion was created for logged-in users only, but now has been archived. No new comments can be posted.

Customer wants to access my database - help!

Comments Filter:

When you go out to buy, don't show your silver.