TMACUL

Quais permissões são necessárias para o usuário servicedesk no MS SQL?

Blog Post created by TMACUL Champion on Feb 6, 2018
  • db_ddladmin
  • db_securityadmin

 

we need to change the "ServiceDesk" database user in MS SQL Server to have db_ddladmin and db_securityadmin privileges under mdb => Security => ServiceDesk => properties => General => Role members.

 

When trying PDM_PUBLISH, getting error 15 - SQL Code=1939 - Can't spawn "cmd.exe". 

 

 

 

 

Move the CA MDB Database on Microsoft SQL Server - CA Service Management - 14.1 - CA Technologies Documentation 

Changing the Service Desk passwords 

Moving the MDB database for Service Desk from one SQL Server instance to another. 

Outcomes