Error trying to deploy a project

• oradbguru

  Hall of Fame

  Points: 3126

  More actions

  August 3, 2016 at 5:34 pm

  #315946

  Hello, I have a user that I set up in the ssis_admin group and they created a new SSISDB folder. When this user tries to deploy a new project in Visual Studio using the Deployment wizard, he is getting the following error:

  The SELECT permission was denied on the object 'projects', database, 'SSISDB', schema 'catalog'.

  (Microsoft SQL Server , Error, 229)

  Any ideas?

• oradbguru

  Hall of Fame

  Points: 3126

  More actions

  August 13, 2016 at 7:19 am

  #1895323

  This issue has been resolved. It turns out all I needed to do was grant access to the Catalog schema.