TechNet
Export (0) Print
Expand All

catalog.explicit_object_permissions (SSISDB Database)

 

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Displays only the permissions that have been explicitly assigned to the user.

Column nameData typeDescription
object_typesmallintThe type of securable object. Securable objects types include folder (1), project (2), environment (3), and operation (4).
object_idbigintThe unique identifier (ID) or primary key of the secured object.
principal_idintThe ID of the database principal.
permission_typesmallintThe type of permission.
is_denybitIndicates whether the permission has been denied or granted. When the value is 1, the permission has been denied. When the value is 0, the permission has not been denied.
grantor_idintThe ID of the principal who granted the permission.

This view displays the permission types listed in the following table:

permission_type ValuePermission NamePermission DescriptionApplicable Object Types
1READAllows 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
2MODIFYAllows 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
3EXECUTEAllows the principal to execute all packages in the project.Project
4MANAGE_PERMISSIONSAllows the principal to assign permissions to the objects.Folder, Project, Environment, Operation
100CREATE_OBJECTSAllows the principal to create objects in the folder.Folder
101READ_OBJECTSAllows the principal to read all objects in the folder.Folder
102MODIFY_OBJECTSAllows the principal to modify all objects in the folder.Folder
103EXECUTE_OBJECTSAllows the principal to execute all packages from all projects in the folder.Folder
104MANAGE_OBJECT_PERMISSIONSAllows the principal to manage permissions on all objects in the folder.Folder

This view does not give a complete view of permissions for the current principal. The user must also check whether the principal is a member of roles and groups that have permissions assigned.

Community Additions

ADD
Show:
© 2016 Microsoft