- About Older Versions
- v7
- Introduction
- Installation
- Start Here
- Container Management
- Advanced Installation
- Securing an Installation
- Silent Installation
- Setting a Fail-over Connection String
- Installing a Failover (HA) Server
- Installing on AWS
- Installing on Azure
- Installing on PostgreSQL
- Installing on an Alternate Port
- Running as a Non Admin User
- Configuring SSL (HTTPS)
- System Settings Overview (settings.xml)
- Configuring Server for HTTPS Redirection
- Storing Encryption Keys
- Changing the Encryption Key
- Load Balancer & Clustering
- Upgrading
- Designer Studio
- Data Structures
- Starting with Data Structures
- Creating Data Structures
- Creating a Case Entity Data Structure
- Creating Entities
- Creating Leased Entities
- Creating External Entities
- Creating an Entity Extension
- Creating Folder Extension Data Structures
- Creating Flow Execution Extension Data Structure
- Creating Flow Structures
- Creating Defined Data Structures
- Creating a Database Structure
- Creating a Value List
- Creating a CSV Data Structure
- Creating Types From JSON Schema
- Creating Configuration Extensions
- Creating Types From XSD
- Data Fields
- Maintaining Data Structures via CRUD Actions
- Managing Data Structures
- Flows
- Starting with Flows
- Steps
- Mapping
- Layout & Design
- Managing Flows
- Sub Flows
- Data & Logic
- Building and Using Converter Flows
- Establishing Constant Data (Global Variables)
- Generating a Unique ID
- Lookup List Flows
- Using Rule Steps in a Flow
- Using a Composite Type as Flow Input Data
- Create Data Pairs
- Schedule Data Entity Overview
- Merging Data Pairs Using the NVelocity Merge Raw Step
- Custom Date & Time Format Strings
- Handling Lists
- Handling Files
- File Type Overview
- Getting File Data From a Document
- Excel/CSV
- Edit And Update Excel Document
- Creating and Styling Excel Document
- Create Excel Data from Object Data
- Adding Header/Footer to Excel Documents
- Splitting Excel Columns by a Custom Delimiter
- Converting CSV to an Excel File
- CSV To List Mapping Step
- CSV To Object Mapping Step
- List to CSV Mapping Step
- Converting an Excel File to CSV
- Appending CSV File Using String Builder
- Using Run Flow For CSV Step
- Import Excel or CSV (Runtime Mappings) Step
- Using the Import Excel or CSV Step
- Using Split Excel Column Step
- Using For Each Excel Or CSV Row Step
- Editing CSV Records in a Form
- Converting CSV/Excel Files to a List of Dynamic Data Rows
- Word/PDF
- SFTP/FTP
- File System
- Handling XML and JSON
- Interacting with Mail Servers
- Debugging
- Best Practices
- Communication
- Flow Behaviors
- About Flow Behaviors
- Flow Step Trigger (After, Before, Error) Flow Behavior
- Folder Count Flow Behavior
- Login User Flow Behavior
- Post to Flow Handler Behavior
- Login User UI Flow Behavior
- Process Folder Data Aware Behavior
- Tile Source Flow Behavior
- Turn Flow Statistics On
- Reporting on Statistics
- Get Page Variable
- Report Field Action Handler Flow
- Step Simulation Path Provided Flow
- Password Reset Handler Flow
- Simple Workflows
- Process Folders
- Caching
- Parallel Processing and Big Data
- Forms
- Starting with Forms
- Form Controls
- Data Grids
- Data Repeaters
- Drop Down Lists
- Javascript Controls
- Form Control Glossary
- Form Control Behavior Overview
- Key Triggers On Form Controls
- Adding a Timeline to a Series of Forms
- Color Picker
- Copy-able Label
- Create Form with Property Grid
- Creating Help Text Messages for Form Fields
- Currency Box and Number Box/Spinner
- Document Viewer On Form
- Editing Data Objects in a Wizard Property Grid
- File References
- File Reference Entity
- Latitude and Longitude Control
- Masked Textbox Control
- Multiple File Upload and Download Controls
- Progress Bar Overview
- Tree View Form Control
- User Controls
- Video Control
- HTML Display Control
- Layout & Design
- Creating Form Backgrounds
- Layouts Overview
- Form Organization
- Grid Layout
- Canvas Layout
- Header Container Layout
- Horizontal and Vertical Stacks
- Split Panel Layout
- Responsive Containers and Grids
- Displaying Form Sections in Tabs Containers
- Using the Tab Editor to Set Tab Order
- Displaying Form Sections with Side Menus
- Creating End Forms
- ADA Compliance with Forms
- CSS
- Data & Logic
- Active Form Flows Overview
- Validation and Visibility Active Form Flows
- Setting Required Value For Outcome Path
- Mapping Form Data Inputs and Outputs
- Displaying Flow Data on Forms
- Displaying an Uneditable Output
- Sub Dialog Data Flow
- Searching a Database with Auto-Complete Search Control
- Form Expiration and Auto Resume
- Legacy
- Assignments
- Simple Forms
- External Form Communication
- Rules
- Starting with Rules
- Managing Rules
- Truth Table
- About Truth Tables
- Creating a Truth Table
- Rule Table Overview
- Returning Multiple Values in Truth Tables
- External Truth Table
- Creating Composite Type in Truth Table
- Calculation on Forms Using Truth Tables
- Using Truth Tables to Dynamically Pass an Image to a Form
- Using Truth Table to Validate Data
- Using Truth Table To Kick Off Actions
- Truth Table Actions
- Changing Truth Table Execution Results
- Debugging
- Expression
- Interceptors & Sets
- Matrix
- Rule Extension
- Rule Chains
- Reports
- Pages / Dashboards
- Starting with Pages
- Page Design
- Page Controls
- Page Control Glossary
- Changing the Style and Behavior of Content and Components
- Report Viewer Control
- Folder Actions and Action Bar Components
- Adding Folder Navigation Buttons to a Page
- Adding Run Flow Links or Buttons to a Page
- Adding User Actions with a Page/Dashboard the Action Bars Component
- Horizontal Folder Timeline
- Filtering Reports via Page Control
- Managing Pages
- Charts
- Tiles
- Business Metrics
- Dynamic Content
- Integrations
- About Integration
- View Integration Details
- API and Authentication
- Integration Settings
- User Interface Integration
- Making Integrations Server Specific
- Testing with JMeter
- Creating WebHooks
- Running a Flow using an Alias
- Calling a Flow as a REST Service
- Agents
- Database Integrations
- Integrating an External Database with a Flow
- Creating Database Table Relationships
- Creating a Database in MSSQL for Decisions
- External Database Integration
- Advanced Postgres Connection
- Integrate with Database Table
- Fetching Data to display in a CSV Editor
- Connecting with an ODBC
- Return Dynamic Data Rows When Fetching Data From Database
- Creating Access Pattern For Table Integrations
- Calling Stored Procedure From Flow to Write Data
- Raw SQL Step
- Integrating Decisions with External Oracle Database
- Locating Tables With the View SQL Action
- Troubleshooting Database Connection Response Times
- External Service for OData
- Adding a Query to External Database
- Parameterized Queries
- Using Transaction Steps
- Connecting to Amazon Redshift
- Managing Database Connection Timeouts
- Connect to MySQL
- Integrating with Snowflake
- External Webservices
- JWT
- Network Integrations
- OAuth
- REST Service Integration
- Using Decisions in External Applications
- Services
- Modules
- Monitering.DataDog Module
- About Modules
- Available Modules
- Installing Modules
- Installing Modules from Github
- Generating Certificates with OpenSSL
- Active Directory
- AWS
- Azure
- Docker
- Docusign
- Dropbox
- Enterprise Module
- Equifax
- Exchange Web Services
- Experian
- FHIR
- Foreign Exchange
- Google Drive
- HL7
- HubSpot
- iCal
- Messaging
- Jira
- MongoDB
- MS OneDrive
- Okta
- OpenID
- PGP
- PowerShell
- Python
- QR Codes
- R Module
- Salesforce
- SAML
- Sharepoint
- Slack
- Telephony
- USPS
- SDK
- Getting Started
- Adding to the Product
- Controlling the Product
- SDK: Creating Custom Flow and Rule Behavior
- SDK: Rule Behavior
- SDK: Text Merge Behavior
- SDK: Text Merge Extensions
- SDK: Creating Custom Folder Behavior
- SDK: Adding Create Actions (Advanced)
- SDK: Custom Step Icons
- SDK: Property Editor Basics Changing Property Classification
- SDK: Property Editor Basics Specifying Editors
- Initialize and Customize
- ORM
- References
- Portal Administration
- Global Debugger
- Deployment
- Jobs and Events
- Portal Look and Feel
- Portal Settings
- Changing Portal Settings and Appearance
- Changing Branding
- Changing Portal Name
- Showing and Hiding Default Page/Folders in Folders Tree
- Hide the Folder Tree Upon Startup
- Setting Default Folder for User and Group in Decisions
- Get Help/Contact Us URL Setup For Decisions Login
- Restricting Data By Rules
- Login Page Customization
- Customizing Default Page Style and Behavior
- Setting up Portal Lock Based on Time
- Custom URL Parameters
- Localization
- System Folders
- System Folders Tree
- Customizing System Page
- System Settings
- System Validation Folder
- Flow Management Dashboard
- System Tools: Event Viewer
- Turn Portal Statistics On
- Report of all Running Flows
- Configuring Locations
- Controlling Assignment Notification Types for Server
- Stored Workflows
- Setting Up Notifications for Events Anywhere in the Portal
- Viewing Portal Services
- Using Locations steps for Holiday dates in Flow
- Using Location steps in Flow
- Toolbox Visibility Rules
- Edit Flow Data While A Flow Is Running
- Permissions
- User Management
- IT Ops Resources
- Best Practices For System/Application Level Error Handling
- Configuring CICD Process Using Azure DevOps
- Advanced
- App Server Health Monitor
- Adding Common Data Elements
- Decisions Developer Debug Mode
- Designer Extensions
- Adding, Moving, and Classifying Entities
- Guide of Decisions Entities Locations in SQL Tables
- Thread Pool Settings
- Using Selenium and NUnit for Front-end Testing
- Database Indexing
- Encryption Overview
- Proxy Configuration
- Server Administration
- Modifying an Application Servers SMTP Settings
- How to Restart the Decisions Application
- Changing the Portal Base URL
- Backup of Decisions Database and File System
- Exploring the Decisions File System Directory (v.7)
- File Storage Structure
- Adding Custom HTTP Headers to a Decisions Installation
- Understanding Decisions Cookies
- Adding Custom HTTP Headers to an IIS Installation
- Logging & Auditing
- Multi Tenant
- Repository
- End User Portal
- v6
- Introduction
- Installation
- Start Here
- Hosting & Configuration
- Container Management
- Advanced Installation
- Securing a Decisions Installation
- Silent Installation
- Setting a Fail-over Connection String
- Installing a Failover (HA) Server
- System Settings Overview (settings.xml)
- Installing on AWS
- Installing on Azure
- Installing Decisions on an Alternate Port
- Setting Up Decisions to Run as a Non Admin User
- Configuring the Server for SSL (HTTPS)
- Install on Root
- Configuring Server for HTTPS Redirection
- Storing Encryption Keys
- Changing the Encryption Key
- Load Balancer & Clustering
- Data Structures
- Starting with Data Structures
- Creating Data Structures
- Creating a Case Entity Data Structure
- Creating Entities
- Leased Entities
- External Entities
- Creating Entity Extension with a Form
- Creating Flow Execution Extension Data Structure
- Creating A Simple Flow Structure
- Creating Defined Data Structures
- Creating a CSV Data Structure
- Creating Types From JSON Schema
- Create Types From XSD
- Data Fields
- Using Data Structures
- Managing Data Structures
- Importing and Exporting Data From Data Structures
- Creating User Actions
- Entity Action Visibility
- Creating Custom Descriptions
- Data Extensions
- Adding Validation Rules to Entities
- Moving Folder Entities with the Flow Designer
- Changing Default Text Length Settings
- Configuration Folder
- Configuration Extensions
- Editing User Action Classification Information
- Replace Data In Configurations (Advanced) Action
- Data Structure CRUD Actions
- Flows
- Starting with Flows
- Layout & Design
- Managing Your Flows
- Sub Flows
- Data & Logic
- Building and Using Converter Flows
- Establishing Constant Data (Global Variables)
- Generating a Unique ID
- Lookup List Flows
- Using Rule Steps in a Flow
- Using a Composite Type as Flow Input Data
- Create Data Pairs
- Schedule Data Entity
- Merging Data Pairs Using the NVelocity Merge Raw Step
- Custom Date & Time Format Strings
- Handling Lists
- Handling Files
- Excel/CSV
- Using the Import Excel or CSV step
- Edit And Update Excel Document
- Creating and Styling Excel Document
- Create Excel Data from Object Data
- Using Split Excel Column Step
- Splitting Excel Columns by a Custom Delimiter
- Converting CSV to an Excel File
- Converting an Excel File to CSV
- Appending CSV File Using String Builder
- List to CSV Mapping Step
- Import Excel or CSV (Runtime Mappings) Step
- Using For Each Excel Or CSV Row Step
- Using Run Flow For CSV Step
- CSV To Object Mapping Step
- CSV To List Mapping Step
- Editing CSV Records in a Form
- Converting CSV/Excel Files to a List of Dynamic Data Rows
- Word/PDF
- SFTP/FTP
- File System
- Getting File Data From a Document
- Excel/CSV
- Interacting with Mail Servers
- Handling XML and JSON
- Debugging
- Best Practices
- Communication
- Flow Behaviors
- About Flow Behaviors
- Using the Form Assignment Handler Flow Behavior
- Folder Count Flow Behavior
- Login User Flow Behavior
- Login User UI Flow Behavior
- Flow Step Trigger (After, Before, Error) Flow Behavior
- Turn Flow Statistics On
- Reporting on Statistics
- Post to Flow Handler Behavior
- Report Field Action Handler Flow
- Tile Source Flow Behavior
- Get Page Variable
- Simple Workflows
- Process Folders
- Caching
- Parallel Processing and Big Data
- Steps
- About Steps
- Step Glossary Guide
- Communication
- Data
- Data Step Glossary
- Using the Create Data Step
- Convert Document Steps
- Formatting Objects With Format Text Step
- Search And Replace Regex
- Regular Expression Steps
- Parse Date with Format Step and Get Formatted Date Step
- Advanced Text Merge Using the NVelocity Component
- Conditionals (if statements) using NVelocity
- Configuring Object Properties With Flow Steps
- Evaluate Expression Steps
- Using String Builder
- Database
- Drawing
- Exchange Web Services Module
- Flow Management
- Flows
- Forms [End]
- Forms [Interaction]
- Integration
- HL7 Module
- Rules
- Get All Items in Folder
- Forms
- Starting with Forms
- Data & Logic
- Layout & Design
- Layout Overview
- Organizing Your Form Overview
- Grid Layout
- Canvas Layout
- Stack Layouts
- Header Container Layout
- Horizontal and Vertical Stacks
- Split Panel Layout
- Responsive Containers and Grids
- Using the Tab Editor to Set Tab Order
- Displaying Form Sections in Tabs Containers
- Setup Forms for Mobile and Tablet Devices
- ADA Compliance with Forms
- Pre-Defined CSS Classes for Forms
- Using CSS in Forms
- Responsive GridLayout with CSS
- Allow Runtime CSS File Name
- Managing Your Forms
- Validation & Visibility
- About Form Validation and Visibility
- Validating Form Data with a Rule
- Validating Form Data with a Flow
- Controlling Form Fields with Visibility Rules
- Using Form Outcomes
- Auto-Exit Form Outcome Rule
- Form Outcome Rules
- Form Components Visibility Using Flow Data
- Hiding Tabs on a Tab Container
- Setting Required Value For Outcome Path
- Form Controls
- Data Grids
- Data Repeaters
- Drop Down Lists
- Javascript Controls
- Form Control Behaviors
- Adding a Timeline to a Series of Forms
- Copy-able Label
- Document Viewer On Form
- Editing Data Objects in a Wizard Property Grid
- File References
- Using the Multiple File Upload and Download Components
- File Reference Entity
- Using the Masked Textbox Component
- Custom Masked Textbox
- Creating Help Text Messages for Form Fields
- Tree View Form Control
- Color Picker
- User Controls
- Progress Bar Overview
- Currency Box and Number Box/Spinner
- HTML Display Control
- External Form Communication
- Assignments
- Rules
- Reports
- Starting with Reports
- Layout & Design
- Interacting with Reports
- Resetting Report Viewer Settings
- Create a Report From a CSV/XLS File
- Refreshing Report Data Automatically Based on Portal Events
- Refreshing Report Data Using a Flow
- Export Report as PDF
- Exporting a Report to Excel (XLSX)
- Child Report Values Dependent on Parent Report Row Selection
- Reporting Snapshots
- Managing Your Reports
- Filtering Reports
- Charts and Views
- Adding Ad Hoc Charts to a Report at Runtime
- Configuring Report View Modes
- Adding Charts to a Report
- Hierarchy View
- Creating Text List and Rich Text Report Views
- Setting Min and Max on Charts
- Creating and Drilling Down into Report Matrix Data
- Using Calculated Fields in a Report Matrix
- Report in Calendar Mode
- Report in Columns View
- Calculated Columns
- Pages / Dashboards
- Designer Studio
- App Store
- Versioning
- Decisions Best Practices
- Designer Studio Settings
- Creating a Designer Folder
- Adding Forms, Flows, and Reports to a Designer Folder
- Copy Designer Folder
- Changing Comment Policy on Save
- Create a Template
- Create a Text Merge
- Object Lock/Release
- Toolbox Visibility Rules
- Recovering Deleted Designer Elements
- Designer Folder Actions Glossary
- Showing Hidden or Deleted Items in a Folder
- Defining Interfaces
- Query Editor
- Assigning Default Designer Templates
- Create Folder and Project Documentation
- Theme Editor
- Dependencies Overview
- Uploading CSS
- Configuring Studio For Multiple Team Use
- Troubleshooting Designer Elements
- Limiting Designer Access to Specific User Groups
- Custom URL Parameters
- Uploading Custom Fonts with CSS
- Integrations
- About Integration
- View Integration Details
- User Context Types and Options
- Creating WebHooks
- Making Integrations Server Specific
- Running a Flow using an Alias
- Agents
- Database Integrations
- Integrating an External Database with a Flow
- Creating Database Table Relationships
- Creating a Database in MSSQL for Decisions
- External Database Integration
- Integrate with Database Table
- Fetching Data to display in a CSV Editor
- Connecting with an ODBC
- Return Dynamic Data Rows When Fetching Data From Database
- Use Flow Steps to Integrate with an External Database
- Alternate Access Pattern For Table Integrations
- Calling Stored Procedure From Flow to Write Data
- Raw SQL Step
- Integrating Decisions with External Oracle Database
- Locating Tables With the View SQL Action
- Troubleshooting Database Connection Response Times
- External Service for OData
- Adding a Query to External Database
- Parameterized Queries
- Using Transaction Steps
- Connecting to Amazon Redshift
- Managing Database Connection Timeouts
- Connect to MySQL
- External Webservices
- JWT
- Network Integrations
- OAuth
- Rest Service Integration
- REST Service Integration Overview
- Calling a Flow as a REST Service
- Integrating a REST Web Service That Returns JSON Data
- Using GET Method With REST Service Integration
- Using POST Method With REST Service Integration
- Sending Composite Data through REST
- Accessing HTTP Headers via Flow
- HTTP and Response Code Error Handling
- Using Decisions in External Applications
- Services
- Modules
- About Modules
- Available Modules
- Installing Modules
- Installing Modules from GitHub
- Generating Certificates with OpenSSL
- Active Directory
- Approval Chain
- AWS
- Azure
- Docker
- Docusign
- Enterprise Module
- Exchange Web Services
- FHIR
- Foreign Exchange
- HL7
- HubSpot
- iCal
- Messaging
- MongoDB
- MSCRM
- Okta
- OPC
- OpenID
- PGP
- PowerShell
- Python
- QR Codes
- Rabbit MQ
- R Module
- Salesforce
- SAML
- Sharepoint
- Slack
- Telephony
- USPS
- SDK
- Getting Started
- Adding to the Product
- Controlling the Product
- SDK: Creating Custom Flow Behavior
- SDK: Text Merge Behavior
- SDK: Text Merge Extensions
- SDK: Creating Custom Folder Behavior
- SDK: Adding Create Actions (Advanced)
- SDK: Custom Step Icons
- SDK: Property Editor Basics Changing Property Classification
- SDK: Property Editor Basics Specifying Editors
- Writing To Log Files
- Initialize and Customize
- ORM
- References
- Administrator Topics
- System and Application Error Handling Overview
- Advanced
- Adding Common Data Elements
- Designer Extensions
- Thread Pool Settings
- API and Authentication
- Decisions Developer Debug Mode
- App Server Health Monitor: HealthCheck.aspx
- Using Selenium and NUnit for Front-end Testing
- Guide of Decisions Entities Locations in SQL Tables
- Database Indexing
- Encryption Overview
- Embedding Decisions Forms In Same Origin iFrames
- Understanding Decisions Cookies
- Deployment
- Export & Import
- Projects
- Repository
- Repository Overview
- Installing and Configuring Designer Repository
- Repository Features and Functions
- Repository FAQ
- Repository Revisions
- Using The Repository
- Using the Repository in a Multi Tenant environment
- Repository Action Flows
- Connecting a Decisions Server to a Repository Server
- Configuring Repository SSO
- Deployment Images
- Jobs and Events
- Localization
- Logging & Auditing
- Multi Tenant
- Multi-Tenant Architecture
- About Multi-Tenancy
- Multi-Tenant Setup
- Registering a Customer in Multi-Tenancy
- Adding a Multi-Tenant Database and Hosting Definition
- Adding an Instance in Multi-Tenancy
- Account Handling in Multi-Tenancy
- Creating Default Tenant Configurations Using Prototype Instance
- Removing a Tenant From Multi-Tenancy
- Setting Up OKTA/SAML on a Multi-Tenant Instance
- Migrating a Control Instance and Tenants to New Databases
- Portal Look and Feel
- Changing Portal Settings and Appearance
- Changing Branding
- Change Portal Name
- Setting Portal Height and Width
- Showing and Hiding Default Page/Folders in Folders Tree
- Hide the Folder Tree Upon Startup
- Setting Default Folder for User and Group in Decisions
- Changing Default Folder for User
- Get Help/Contact Us URL Setup For Decisions Login
- Changing Minimum Portal Size
- Restricting Data By Rules
- Login Page Customization
- Setting up Portal Lock Based on Time
- Portal Settings
- Server Administration
- Modifying an Application Servers SMTP Settings
- Server Performance Testing
- How to Restart Service Host Manager
- Changing the Portal Base URL
- Backup of Decisions Database and File System
- Exploring the Decisions File System Directory (v.6)
- Configuring Decisions to use a Systemwide Proxy
- Adding Custom HTTP Headers to a Self-Hosted Installation
- System Folders
- System Folders Tree
- System Settings Overview
- System Validation Folder
- Flow Management Dashboard
- System Tools: Event Viewer
- Controlling Assignment Notification Types for Server
- Turn Portal Statistics On
- Report of all Running Flows
- Configuring Locations
- Stored Workflows
- Setting Up Notifications for Events Anywhere in the Portal
- Viewing Portal Services
- Using Locations steps for Holiday dates in Flow
- Using Location steps in Flow
- Edit Flow Data While A Flow Is Running
- Decisions URL Paths
- User Management
- End User Portal
SQL Server Database Permissions
- Updated on 11 Jan 2022
- 3 Minutes to read
- Suggest Edit
- Print
- Share
- DarkLight
Decisions and SQL Server
Versions
Decisions can be used with SQL 2008 R2 or SQL 2012. With SQL 2012, there are increased restrictions on the default permissions for automatically setup users, so it is strongly recommended to use SQL authentication instead of SSPI.
Authentication
SSPI
SSPI, or Integrated Security, uses the Windows environment and users to identify rights and access to the SQL server system. This is commonly used in Active Directory or LDAP based enterprises to centralize control and access to systems and services.
SSPI can be used with the SQL server. Still, you must be aware of what user(s) on the server will be running the Service Host Manager service and ensure that the user is granted the appropriate permissions to run services and connect to SQL; please seek support from your IT administrator before using this configuration.
SQL Auth
SQL authentication is a system of logging in users based on settings in the SQL server itself. This lacks central control but is very straightforward to configure. It is recommended to use SQL auth with SQL 2012 due to the increased security in SQL 2012.
Standard User
The Decisions installer and platform take care of most Database activities for an application. This includes many of the following:
Creating an initial Database or tablespace
Creating and altering tables
Configuration of Indexes
To perform these activities, the installer and service need to have the "db_creator" permissions on the Database.
Limiting User
There is the ability to create a limited user in the SQL server, but this requires doing some of the Database setup and configuration manually.
To configure Decisions in this manner, create a new Database in the SQL server. Once the Database is named, identify, or create a user that will use this Database. Using the tools, grant this user rights on the Database that was created.
The following roles can be assigned as membership roles and do not need to be owned roles in SQL Server.
Note that the following three permissions are the lowest database permission levels that can be used for installing Decisions using SQL Server.
db_datawriter
db_datareader
db_ddladmin
These roles can be assigned as ‘membership roles’ and do not need to be ‘owned roles’ in SQL Server.
The Database user must also have the following explicit permissions on the Decisions Database:
ALTER ANY SCHEMA
EXECUTE
ALL (*see section below for more information)
Before installation and while Decisions is in use, the Database user must have all of the following permissions granted on the Decisions Database, either implicitly or explicitly:
Configure this user’s default Database to be used in SQL Server, although this default DB does not need to be the same Database as Decisions is using.
ALTER ANY SCHEMA
BACKUP DATABASE, BACKUP LOG
CONNECT,
CREATE DEFAULT, CREATE FUNCTION, CREATE PROCEDURE, CREATE RULE, CREATE TABLE, CREATE VIEW
EXECUTE
Enabling ALL
Note that the ALL permission has since been deprecated and can only be applied by using a query or through manual selection under Database Properties.
Via Database Properties
To enable ALL via Database Properties:
- Open and login to Microsoft SQL Server Management Studio.
- From the Object Explorer in Microsoft SQL Server Management Studio, right-click the desired Database and select Properties.
- Navigate to the Permissions page and select the desired User from the Users or roles list.
- From the Permissions for [username] list, check Grant for the following permissions, then click OK.
- Backup database, Backup log
- Connect
- Create default, Create function, Create procedure, Create rule, Create table, Create view
Via Query
To enable ALL via Database Query:
- From Microsoft SQL Server Management Studio, right-click the desired Database and select New Query.
- In the resulting Query tab, input the following text. Note on QueryRunning the following Query give the configured Account Admin permissions as well as the ALL permission. To properly set it up, set the primary database name, non-admin login name, non-admin login password, and non-admin user name values to respective values.
use <primary database name>; go CREATE LOGIN <non-admin login> WITH PASSWORD ='<non-admin login password>', DEFAULT_DATABASE = <primary database name>; go CREATE USER <non-admin user> FOR LOGIN <non-admin login> go GRANT ALTER ANY SCHEMA to <non-admin user> GRANT EXECUTE to <non-admin user> GRANT ALL to <non-admin user> EXEC sp_addrolemember N'db_datareader', N'<non-admin user>' EXEC sp_addrolemember N'db_datawriter', N'<non-admin user>' EXEC sp_addrolemember N'db_ddladmin', N'<non-admin user>'
PL/SQL Select the Execute button from the top Action bar.
Open DecisionsServerInstaller.exe and select EDIT SETTINGS. From the Settings screen, edit the DatabaseConnectString so that the User ID and Password values match the non-admin user Account. Then, click Save.
Back on the primary Decisions Installer screen, select RESTART SERVICE then confirm with Yes.