Is it possible to detect that a database connection is to a copy rather than to the original database?

Posted by user149238 on Server Fault See other posts from Server Fault or by user149238
Published on 2012-12-11T22:07:12Z Indexed on 2012/12/11 23:05 UTC
Read the original article Hit count: 227

I have an application that needs to know if it is connected to the original database that it was installed with or if the connection is to a copy of that database. Is there any known method to know if the database has been cloned and the application is no longer connected to the original? I am specifically interested in MS SQL Server and Oracle.

I was kicking ideas around for a stored procedure but that most likely doesn't have access to the hardware to confirm unique hardware information that would somewhat guarantee that the database is the one that it was originally connected to during installation.

I'm trying to prevent/detect cloning of a database so that there is only 1 "true location of truth".

Thanks!

© Server Fault or respective owner

Related posts about security

Related posts about database