.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Melody Anderson

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

How to lock the databse..

Posted By: susant     Posted Date: December 11, 2008    Points:2   Category :Sql Server

How to protect structures(Tables,SP,Views and Functions) of a SQL
Server Database?(Password protect a database file)
I have a SQL database that will distribute with my application, I want to protects it's structure from my appliction users. Only my
application can access the database.

the sql2005 also contain some other databases but i wnat to l0ck the specific database...

example say..
i have three database
1: inventory
2: INFITECH-> this is my database which i am using for my application
3: master

so my requiremnt like i wnat to lock INFITECH database not others...

Author: Rahul             
Posted Date: December 11, 2008     Points: 5   

You can create user and assign that user to use that DataBase you can also set the rules for each user. to do this

To create user goto - >Security ->Right click (New Login)

To assign the user to a DataBase

Right click on DataBase->Properties->Permisson->Add-> Then select Newly Craeted user

Author: susant             
Posted Date: December 12, 2008     Points: 5   

Hi Rahul..

i just create user and add the permision but when ever any user logon as giving "Windows authentication he can access my database"...

so how to prevent all other user to access database....

Post Reply

You must Sign In To post reply
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend