用户名-数据库密码 [英] username - password for database

问题描述

我如何保护我的数据库，但谁又不能附加它呢?

how i can protect my database who, they can''t attach it

推荐答案

我认为透明数据加密(TDE)将解决您的问题.

请看看这些资源:
http://www.mssqltips.com/sqlservertip/1514 /sql-server-2008-transparent-data-encryption-getting-started/ [ http://www.simple-talk.com/sql/database-administration/transparent -data-encryption/ [ ^ ]

http://sqldbpool.com/2011/11/23/transparent-data-encryption/ [ ^ ]

希望对您有所帮助.

I think Transparent Data Encryption (TDE) will solve your problem.

Please have a look at these resources :
http://www.mssqltips.com/sqlservertip/1514/sql-server-2008-transparent-data-encryption-getting-started/[^]

http://www.simple-talk.com/sql/database-administration/transparent-data-encryption/[^]

http://sqldbpool.com/2011/11/23/transparent-data-encryption/[^]

Hope it helps.

您没有提到您的SQLServer版本.

请执行以下步骤:
1)打开SqlServer Management Studio> [YOUR DATABASE]> Security > Roles
2)右键单击"Database Roles"，选择"New Database Role".
3)单击"Securables"，然后选择要分配给该角色的其他数据库roles，objects等.之后，单击确定".数据库角色现在应出现在your database/security/roles下的"Database Roles"列表中. 4)将权限分配给your database角色.仅将权限分配给absolutely necessary的数据库角色.

有关更多信息，请访问数据库级角色
了解SQL Server角色
创建用户定义的SQL Server数据库角色

You didn''t mention your SQLServer Version.

Use the following steps:
1) Open your SqlServer Management Studio > [YOUR DATABASE]> Security >Roles
2) Right click over "Database Roles", select "New Database Role".
3)Click on "Securables" and select other database roles, objects, etc to be assigned to that role. After that click "OK." The database role should now appear in the "Database Roles" listing under your database/security/roles.
4)Assign permissions to your database role. Only assign permissions to the database role that are absolutely necessary.

For further information please visit here
[UPDATED]
To Learn more about database role please visit the following links:

Database-Level Roles
Understanding SQL Server Roles
Creating User-Defined SQL Server Database Roles

他们是谁?

通过使用SQL登录名和角色来保护数据库，而不是将密码发布给不需要密码的用户.而且永远不要使用SA帐户进行访问.

Who are they?

You protect your database by using SQL Logins and roles and not publishing the password to those who don''t need it. And don''t ever use the SA account for access.

这篇关于用户名-数据库密码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！