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

Available Languages

Updated:May 3, 2012

Document ID:113507

Bias-Free Language

The documentation set for this product strives to use bias-free language. For the purposes of this documentation set, bias-free is defined as language that does not imply discrimination based on age, disability, gender, racial identity, ethnic identity, sexual orientation, socioeconomic status, and intersectionality. Exceptions may be present in the documentation due to language that is hardcoded in the user interfaces of the product software, language used based on RFP documentation, or language that is used by a referenced third-party product. Learn more about how Cisco is using Inclusive Language.

Introduction

Prerequisites

Requirements

Components Used

Problem

Solution

Related Information

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:

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
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.
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.