Hide a Database in SQLserver2005

Question

2.00/5 (1 vote)

See more:

SQL-Server-2005

hi,
am using Sqlserver2005 as a backend, i need to install my .net application in Client place. i need to access the DB through application. But i dont want the client to see the Database and it's Tables, procedures in SqlServer2005. But they want to be access the DB thro application.

In this scenario what i want to do?
either

1. i want to hide the DB in SQL Server
(or)
2. Set a Password/Permission for DB

Note: the DB should access by the application from several users,
They could not view the DB and it's objects directly from SQLManagement studio.

Thanks in Advance for your Valuable Help.......
---Karthika

Posted 22-Feb-12 20:35pm

karthika -chennai

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ganesan Senthilvel · Answer 1 · 2012-02-22T20:44:00

Solution 1

Create a separate SQL User ID for your application. You need to grant the access to the specified DB, only to Application User ID; not other users. Hope, this will resolve the issue.

Posted 22-Feb-12 20:44pm

Ganesan Senthilvel

Comments

karthika -chennai 23-Feb-12 3:10am

dear ganesh,
i will install the application to 'n' No of users. How can i get the Application User ID.
i dont have any idea about Application User Id & SQL user ID too....
another thing, whenever i want to make change in SQl it should allow me only...
thanks in advance.........

Varun Sareen · Answer 2 · 2012-02-22T20:48:00

Dear Friend,

These links will prove to be of much help to you:-

http://www.mssqltips.com/sqlservertip/1718/database-level-permissions-for-sql-server-2005-and-2008/[^]

http://www.databasejournal.com/features/mssql/article.php/10894_2246271_2/Managing-Users-Permissions-on-SQL-Server.htm[^]

http://msdn.microsoft.com/en-us/library/ms178569.aspx[^]

http://msdn.microsoft.com/en-us/library/ms365317.aspx[^]

http://msdn.microsoft.com/en-us/library/ff461429.aspx[^]

http://msdn.microsoft.com/en-us/library/dd301223.aspx[^]