第 2 课:配置数据库对象的权限Lesson 2: Configure permissions on database objects
07/31/2018
本文内容
适用于:
SQL Server
Azure SQL 数据库
Azure Synapse Analytics
并行数据仓库
授予用户访问数据库的权限涉及三个步骤。Granting a user access to a database involves three steps. 首先,创建登录名。First, you create a login. 使用登录名,用户可以连接到 SQL Server 数据库引擎SQL Server Database Engine。The login lets the user connect to the SQL Server 数据库引擎SQL Server Database Engine. 然后将登录名配置为指定数据库中的用户。Then you configure the login as a user in the specified database. 最后,授予该用户访问数据库对象的权限。And finally, you grant that user permission to database objects. 本课介绍了这三个步骤,并介绍了如何将视图和存储过程创建为对象。This lesson shows you these three steps, and shows you how to create a view and a stored procedure as the object.
备注
This lesson relies on objects created in Lesson 1 - Create database objects. 请在学习第 2 课之前,先完成第 1 课。Complete Lesson 1 before continuing on to lesson 2.
先决条件Prerequisites
若要完成本教程,需要 SQL Server Management Studio 以及针对 SQL Server 实例的访问权限。To complet