localdb 怎样添加密码连接

Question

想access数据库一样 有一个连接密码

提高数据的保密性

Answer 1

您好，

您可以在 VS.NET 中的 SQL Server 物件總管，開啟 localdb ，

然後在 安全性->登入 裡面去新增 有密碼的登入者 。

---

亂馬客blog: http://www.dotblogs.com.tw/rainmaker/

Answer 2

Hello,

或者尝试用SQL 系统存储过程语句:

use WinRTDB

sp_addlogin 'LoginName','Password'

exec sp_grantdbaccess 'LoginName','LoginName'

GRANT INSERT,UPDATE,DELETE,SELECT ON [dbo].[__MigrationHistory] TO [LoginName];

Regards.

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.