Cisco Cisco Process Orchestrator 3.0 Guida All'Installazione

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

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.

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

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: 

SAP tables (SNAP and EDIDC)

V$lock

V$session

V$sqlarea