sql server 2005-- [英] sql server 2005--

问题描述

您好，我想在sql server-2005中设置数据库密码吗?

hi i want to set database password in sql server-2005 is ther any way i could achieve this???

推荐答案

通常您不能放数据库本身的密码.任何一个数据库的安全性都通过登录安全性来控制.

展开安全性，然后右键单击登录"，然后单击登录".并创建您的用户帐户.在单击确定"创建SQL登录ID之前，请单击用户创建"窗口左侧的映射"链接.在您要允许访问的数据库的名称旁边打一个勾号.不要忘记将基本权限添加到用户帐户(与底部的数据库分配位于同一窗格中).默认情况下，它仅允许读取数据库中的值.如果该用户将是所有者"，请确保将该权限分配给该帐户.

Typically you can''t put a password on the database itself. The security for any one database is controlled through the login security.

Expand the security and right click on "Logins" and create your user account. Before you click OK to create thh SQL login ID, click on the Mappings link on the left side of the user creation window. Place a check mark by the name of the database you want to allow access to. Don''t forget to add the base permission to the user account (that is in the same window pane as the database assignment on the bottom). By default it just allows for reading values in the DB. If this user will be the "Owner" make sure to assign that permission to the account.

这篇关于sql server 2005--的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！