Bad SQL Queries

From Slashdot | Keeping Customer From Accessing My Database?

Partial data replication (Score:5, Insightful)

by netsavior (627338) on Friday May 16, @01:41PM (#23436638)
Homepage

For the love of science do not give them access to your production database, they WILL screw it up, even with just read access.
Here is the psudocode from their SQL:
Select * from everything join everything where non-indexed column like ‘%’

you need to make them a COPY of the data that they are allowed to access on a seperate database (preferably a seperate server). Most reasonable replication suites allow you to do things like this.

[Slashdot] [Digg] [Reddit] [del.icio.us] [Facebook] [Technorati] [Google] [StumbleUpon]

Comments are closed.