Cisco Cisco Process Orchestrator 3.0 インストールガイド
1-13
Cisco Process Orchestrator Installation Guide
OL-24931-02
Chapter 1 Installation Prerequisites
Configuration Access Requirements
GO
IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N' orchestratorprocess ')
DROP USER [orchestratorprocess]
GO
CREATE USER [orchestratorprocess] FOR LOGIN [orchestratorprocess] WITH
DEFAULT_SCHEMA=[dbo]
GO
EXEC sp_addrolemember N'db_datareader', N' orchestratorprocess '
GO
EXEC sp_addrolemember N'db_datawriter', N' orchestratorprocess '
GO
Reporting Database Authentication Script
Use the following logon script to create a SQL user account for the OrchestratorReporting reporting
database. The assumption is that the OrchestratorReporting database will be created by a sysadmin
account first, after which the script can be used to create a OrchestratorReporting database account with
limited permission, and change reporting database to use the OrchestratorReporting user account.
database. The assumption is that the OrchestratorReporting database will be created by a sysadmin
account first, after which the script can be used to create a OrchestratorReporting database account with
limited permission, and change reporting database to use the OrchestratorReporting user account.
IF EXISTS (SELECT * FROM sys.server_principals WHERE name = N'OrchestratorReporting')
DROP LOGIN [OrchestratorReporting]
GO
CREATE LOGIN [OrchestratorReporting] WITH PASSWORD=N'cpo',
DEFAULT_DATABASE=[OrchestratorReporting],
CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
--For Windows authentication
--CREATE LOGIN [domain\userID] FROM WINDOWS WITH DEFAULT_DATABASE=[OrchestratorReporting]
GO
USE [OrchestratorReporting]
GO
IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N'OrchestratorReporting')
DROP USER [OrchestratorReporting]
GO
CREATE USER [OrchestratorReporting] FOR LOGIN [OrchestratorReporting] WITH
DEFAULT_SCHEMA=[dbo]
GO
EXEC sp_addrolemember N'db_datareader', N'OrchestratorReporting'
GO
EXEC sp_addrolemember N'db_datawriter', N'OrchestratorReporting'
GO
GRANT EXECUTE TO OrchestratorReporting
GO
Oracle Database Access Rights
If using an Oracle database, Cisco recommends that the user account be assigned read access rights to
all tables and views. The following minimum access rights must be assigned to the user account:
all tables and views. The following minimum access rights must be assigned to the user account:
•
SAP tables (SNAP and EDIDC)
•
V$lock
•
V$session
•
V$sqlarea