TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

catalog.revoke_permission (SSISDB Database)

 

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

Revokes a permission on a securable object in the Integration Services catalog.

  
revoke_permission [ @object_type = ] object_type  
    , [ @object_id = ] object_id  
    , [ @principal_id = ] principal_id  
    , [ @permission_type = ] permission_type  

[ @object_type = ] object_type
The type of securable object. Securable objects types include folder (1), project (2), environment (3), and operation (4).The object_type is smallint.

[ @object_id = ] object_id
The unique identitifier (ID) of the securable object. The object_id is bigint.

[ @principal_id = ] principal_id
The ID of the principal to be revoked permission. The principal_id is int.

[ @permission_type = ] permission_type
The type of permission. The permission_type is smallint.

0 (success)

1 (object_class is not valid)

2 (object_id does not exist)

3 (principal does not exist)

4 (permission is not valid)

5 (other error)

None

None

This stored procedure requires one of the following permissions:

  • ASSIGN_PERMISSIONS permissions on the object

  • Membership to the ssis_admin database role

  • Membership to the sysadmin server role

If permission_type is specified, the stored procedure removes the permission that is explicitly assigned to the principal for the object. Even if there are no such instances, the procedure returns a success code value (0). If permission_type is omitted, the stored procedure removes all permissions of the principal to the object.

System_CAPS_ICON_note.jpg Note


The principal may still have the specified permission on the object if the principal is a member of a role that has the specified permission.

This stored procedure allows you to revoke the permission types described 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

Community Additions

ADD
Show:
© 2016 Microsoft