Can I make my database to work only for particular web site and not any other

Question

Can I make my database to work only for particular web site and not any other

mcasuman2004

SSC Enthusiast

Points: 135
More actions
July 1, 2011 at 12:23 pm

#389881

Hi,
I need some help on having security for my database.
Can I make my database to work only for my site.
For Eg:- If I have hosted my site on shared network the person who has hosted will know the user name and password. So there is a chance of theft of the source code and database,
So i would like to have a database security in such a way that it should only work for my hosted site and not any other site(Even if some one takes my code it should not work)

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281344 More actions · Answer 1

If you are storing your connection details in clear text - you are somewhat limited.

You could try to implement a logon trigger that denies any traffic from outside of the IP address of your hosted site. But that doesn't prevent unwanted traffic from that server.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Lowell SSC Guru Points: 323546 More actions · Answer 2

if you are not hosting it yourself, you just have to trust that the DBA is a professional, and does not to want to steal your data

there's another thread running now where someone wanted to lock out of their data...it just cannot be done.

"RE: Restricting DBA from accessing SQL DB objects" in "SQL Server 2008 - General"

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 3

mcasuman2004 (7/1/2011)
Hi,
I need some help on having security for my database.
Can I make my database to work only for my site.
For Eg:- If I have hosted my site on shared network the person who has hosted will know the user name and password. So there is a chance of theft of the source code and database,
So i would like to have a database security in such a way that it should only work for my hosted site and not any other site(Even if some one takes my code it should not work)

I'll add to the general conceptual abuse of the principal. If you do not control SA rights, you cannot control who has access to your data or code. The only way to be utterly secure in access it to be utterly secure in hardware access.

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA