Set permission to DB

Is there any possibilities to make a Db private in sql server 2005. I mean o开发者_高级运维nly one user must can access and edit the others should not view and edit..

You can choose who can edit and log on the database of course. You actually choose this while creating the databsae by choosing a username and password and you can add or remove users later as long as you are the administrator. Make sure yo choose SQL Server Authentication not Windows.

You need to set up the users and logins and permissions.

Start here.

• on the sql server create a login. this can can one of two types either a windows account or a sql account
• in the database map that login to a user. Give that user all the permission they need
• remove all the other uers or deny them the permissions

In addition to the obvious and mentioned security settings available, you can also set the database in Single-user mode and reduce your surface area by turning off access to TCP/IP via the Surface Area Configuration Tool.