Sql Server – Integration Services Catalogs – Permission Management Using SSMS

Background

Let us quickly review how we can use SQL Server Management Studio (SSMS) to manage the Integration Services Catalogs.

 

Lineage

Here is our journey so far …

  1. Sql Server – Integration Services – SSIS Catalog ( SSISDB ) – Metadata – List Parameters
    Link
  2. Sql Server – Integration Services – SSIS Catalog ( SSISDB ) – Metadata – List Permissions
    Link

 

 

SQL Server Management Studio ( SSMS )

Outline

Here are the steps:

  1. Launch SQL Server Management Studio ( SSMS)
  2. Connect to the SQL Server Instance
  3. Under the SQL Server Instance, if an Integration Service Catalog has previously been created, look for the Integration Services Catalog Node
  4. Under the Integration Services Catalog Node, the database will appear
  5. Access the database, review the list of folders listed
    • Under each folder, Projects and Environments are listed
  6. We will be granting permissions at the Folder level
  7. Return to the Folder, right click on the Folder and from the dropdown menu select “Folder Properties”
  8. The Folder Properties window appears
    • In the Folder Properties window there are two pages, the General and Permissions
  9. In the Folder Properties window access the Permissions page
  10. The permissions available at the Folder Level appears
    • The permissions available includes Read, Modify, Manage Permissions, Create Objects, Modify Objects, Execute Objects, Read Objects, and Manage Object Permissions
    • Delegation of Tasks
      • For developers, the most common permissions to grant are the read permissions ( Read & Read Objects )
      • For Operation DBAs, all permissions outside of execute permissions can be granted
      • Ffr the Proxy Service account that scheduled jobs will run under, please grant the Read and Execute permissions

 

Image

Object Explorer

Folder Properties

Folder Properties – Permissions

 

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s