用户和登录sql服务器有什么区别？ [英] what is the difference between user and login sql sever?

问题描述

请告诉我用户和登录sql server之间的区别...？

please tell me the difference between user and login in sql server...?

推荐答案

登录定义您访问SQL Server。登录后，您可以与数据库进行通信。登录具有身份验证的定义（用户名和密码或Windows身份验证），对于登录，您可以定义服务器范围的权限。



用户改为定义对单个数据库的访问权限在您登录的同一SQL Server中。用户定义包含该数据库中的权限定义。例如，如果您的SQL Server实例有5个数据库，您的登录可能只能访问其中的2个数据库，因此它是两个数据库中的用户。



查看语句创造两者。它会解释很多：

- 创建登录 [< a href =https://msdn.microsoft.com/en-us/library/ms189751.aspxtarget =_ blanktitle =New Window> ^ ]

- 创建用户 [ ^ ]

Login defines you access to the SQL Server. Having a login let's you communicate with the database. The login has definition for the authentication (username and password or windows authentication) and for a login you can define server wide privileges.

User instead defines access to a single database within the same SQL Server where you have a login. User definition contains privilege definitions inside that database. For example if your SQL Server instance has 5 databases your login may have access only to 2 of those so it's a user in two databases.

Have a look at the statements for creating both. It'll explain a lot:
- CREATE LOGIN[^]
- CREATE USER[^]

这篇关于用户和登录sql服务器有什么区别？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！