Hi all.. Is there any possibilities to make a Db private in sql server 2005. I mean only one user must can access and edit the others should not view and edit..
A:
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.
Ahmad Farid
2010-10-13 12:43:45
Other user (not for sa account) can do like this ..Then how to set password in ssms
Jafry
2010-10-13 12:50:10
A:
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
Preet Sangha
2010-10-13 12:44:50
A:
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.
Brad
2010-10-13 14:57:46