dbowner

datareader, datawriter

datareader, datawriter, all roles named with a prefix of bp_dba

sysowner

all of the above

Each Blue Prism environment (e.g. Dev/UAT/Prod) will have a single database

Each Blue Prism environment (e.g. Dev/UAT/Prod) will potentially have many databases

Each Blue Prism environment (e.g. Dev/UAT/Prod) can have many Application Servers but they will all connect to the same database

Each Blue Prism environment (e.g. Dev/UAT/Prod) can have may Application Servers but they will all connect to the same database

Each Blue Prism environment (e.g. Dev/UAT/Prod) can have one Application Server but can connect to many databases

Using a Blue Prism device, create a device database connection to connect to the server, use the in-product “Create Database” functionality

Using a Blue Prism device, connect to the Blue Prism Application Server, use the in-product “Create Database” functionality

Using SQL Management Studio create a database, manually run the CreateScript provided by Blue Prism, then use in-product “Configure Database” functionality

Using SQL Management Studio manually run the CreateScript provided by Blue Prism to generate to the database, then use the in-product “configure Database” functionality