MS SQL Server 2016+/AzureDB
Disk drive performance is crucial in terms of SQL DB data flow.
The disk size depends on the data required.
Consult our technicians for more precise requirements.
1. Create role and schemas in the database (schemas depend on the data that will be used)
CREATE ROLE [role_combocurve_agent] AUTHORIZATION [dbo];
GO
CREATE SCHEMA [CCStage] AUTHORIZATION
[role_combocurve_agent];
GO
CREATE SCHEMA [enverus] AUTHORIZATION
[role_combocurve_agent];
GO
CREATE SCHEMA [ihs] AUTHORIZATION
[role_combocurve_agent];
GO
CREATE SCHEMA [ihsrest] AUTHORIZATION
[role_combocurve_agent];
GO
CREATE SCHEMA [combocurve] AUTHORIZATION
[role_combocurve_agent];
GO
2. Set Agent’s account as a member of the role role_combocurve_agent
EXEC sp_addrolemember 'role_combocurve_agent', '***account***'
GO
GRANT CREATE TABLE TO [***account***]
GO
3. GRANT SELECT on all required data
1. Set Agent’s account as a member of the roles
EXEC sp_addrolemember 'db_ddladmin', '***account***'
GO
EXEC sp_addrolemember 'db_datareader', '***account***'
GO
EXEC sp_addrolemember 'db_datawriter', '***account***'
GO