Cisco Process Orchestrator: How to Create SQL Server TEOReporting Users with Minimum Access

Introduction

This document provides information on how to create a user for the TEOReporting Database in Microsoft SQL Server with the minimum required access.

Prerequisites

Requirements

There are no specific requirements for this document.

Components Used

The information in this document is based on the Cisco Process Orchestrator.

The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, make sure that you understand the potential impact of any command.

Problem

Customers want to create SQL users to use with TEOReporting and want to assign access.

Note: The TEOReporting Database must be created with an admin account first. This is only valid after the database has been created.

Solution

Complete these steps:

1. Use this script:

   CREATE LOGIN TIAReport WITH PASSWORD = 'teo_user01'; Use TEOReporting CREATE USER TIAReport FOR LOGIN TIAReport WITH DEFAULT_SCHEMA = TIAReport GO CREATE ROLE db_executor authorization TIAReport GRANT EXECUTE TO db_executor GO exec sp_addrolemember 'db_executor', TIAReport exec sp_addrolemember 'db_datareader', TIAReport exec sp_addrolemember 'db_datawriter', TIAReport exec sp_addrolemember 'db_ddladmin', TIAReport GO

2. Change the user account inside of CPO by going to the master console. Then, go to Administration > Database Settings > Reporting Database. Open the Report Database Configuration and change the user.

3. In SQL Management Studio, look for any TEOReporting SQL jobs in the SQL Server Agent. Update each job's owner to be the new TIAReport user you just created.

Related Information

• Technical Support & Documentation - Cisco Systems