[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 359
  • Last Modified:

SQL Server Database and table structure prevent unauthorized access

Is there a way to prevent unauthorized access or even to view the table structure in a hosting server.
0
MadhuMenong
Asked:
MadhuMenong
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
the hosting provider has DBA access to the db, so those people basically can see anything in your database (and you have no means to block that).

so, if it really has to be blocked to "anybody", don't "host" your database on a normal (web) hosting provider.
0
 
lcohanDatabase AnalystCommented:
Aside of the hosting people that would have access to your server and implicit database, you should implement your own security model and you can read details about how to do that at the links below and I suggest and recommend create standard database role(s), then assign minimum rights on your DB objects to the role(s) and add user sql logins to the standard database role:

http://www.google.ca/url?sa=t&source=web&cd=1&ved=0CBkQFjAA&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F8%2F5%2Fe%2F85eea4fa-b3bb-4426-97d0-7f7151b2011c%2FSQL2005SecBestPract.doc&ei=dr5vTZ3mLMaitgfIvpH-Dg&usg=AFQjCNFv2JoFJvPxIp1ArMuUJQSSwKKC4g

http://www.sqlsecurity.com/FAQs/SQLSecurityChecklist/tabid/57/Default.aspx

As you didn't mentioned what SQL server you are using please select the appropriate 200/2005/2008


0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now