catalog.effective_object_permissions(SSISDB 数据库)catalog.effective_object_permissions (SSISDB Database)

适用范围:SQL Server,包括 Linux Azure SQL 数据库yesAzure SQL 数据仓库no并行数据仓库 APPLIES TO: yesSQL Server, including on Linux yesAzure SQL Database yesAzure SQL Data Warehouse noParallel Data Warehouse

适用对象: yesSQL ServeryesAzure SQL 数据库noAzure SQL 数据仓库no并行数据仓库APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

显示 Integration ServicesIntegration Services 目录中所有对象的当前主体的有效权限。Displays the effective permissions for the current principal for all objects in the Integration ServicesIntegration Services catalog.

列名Column name 数据类型Data type 描述Description
object_typeobject_type smallintsmallint 安全对象的类型。The type of securable object. 安全对象类型包括文件夹 (1)、项目 (2)、环境 (3) 和操作 (4)。Securable objects types include folder (1), project (2), environment (3), and operation (4).
object_idobject_id bigintbigint 对象的唯一标识符 (ID) 或主键。The unique identifier (ID) or primary key of the object.
permission_typepermission_type smallintsmallint 权限的类型。The type of permission.

RemarksRemarks

此视图显示下表中所列的权限类型:This view displays the permission types listed in the following table:

permission_type 值permission_type Value 权限名称Permission Name 权限说明Permission Description 适用对象类型Applicable Object Types
1 READREAD 允许主体读取被视为对象一部分的信息(如属性)。Allows the principal to read information that is considered part of the object, such as properties. 它不允许主体枚举或读取该对象中包含的其他对象的内容。It does not allow the principal to enumerate or read the contents of other objects contained within the object. 文件夹、项目、环境、操作Folder, Project, Environment, Operation
2 MODIFYMODIFY 允许主体修改被视为对象一部分的信息(如属性)。Allows the principal to modify information that is considered part of the object, such as properties. 它不允许主体修改该对象中包含的其他对象。It does not allow the principal to modify other objects contained within the object. 文件夹、项目、环境、操作Folder, Project, Environment, Operation
3 在运行 CREATE 语句前执行EXECUTE 允许主体执行项目中的所有包。Allows the principal to execute all packages in the project. 项目Project
4 MANAGE_PERMISSIONSMANAGE_PERMISSIONS 允许主体向对象分配权限。Allows the principal to assign permissions to the objects. 文件夹、项目、环境、操作Folder, Project, Environment, Operation
100 CREATE_OBJECTSCREATE_OBJECTS 允许主体在文件夹中创建对象。Allows the principal to create objects in the folder. 文件夹Folder
101 READ_OBJECTSREAD_OBJECTS 允许主体读取文件夹中的所有对象。Allows the principal to read all objects in the folder. 文件夹Folder
102 MODIFY_OBJECTSMODIFY_OBJECTS 允许主体修改文件夹中的所有对象。Allows the principal to modify all objects in the folder. 文件夹Folder
103 EXECUTE_OBJECTSEXECUTE_OBJECTS 允许主体执行文件夹中所有项目的所有包。Allows the principal to execute all packages from all projects in the folder. 文件夹Folder
104 MANAGE_OBJECT_PERMISSIONSMANAGE_OBJECT_PERMISSIONS 允许主体管理文件夹中所有对象的权限。Allows the principal to manage permissions on all objects in the folder. 文件夹Folder

只评估调用方对其具有权限的对象。Only objects on which the caller has permissions are evaluated. 权限基于以下各项进行计算:The permissions are computed based on the following:

  • 显式权限Explicit permissions

  • 继承的权限Inherited permissions

  • 角色中主体的成员身份Membership of the principal in roles

  • 组中主体的成员身份Membership of the principal in groups

权限Permissions

用户只可查看其自己的权限以及他们作为成员的角色的权限。Users can see effective permissions only for themselves and for roles of which they are members.