What are the database permissions required to set up Bold Reports®?
Bold Reports® needs certain permissions assigned to your database username to create and use a database. The following list shows which permissions let Bold Reports® connect to and use the database.
Which permissions does the database user need?
The credentials that Bold Reports® uses to connect to the server instance must have the following permissions:
- Create Table: permission to create tables required for the applications.
- Insert: permission to add new records to the tables.
- Update: permission to update existing records in the tables.
- Alter: permission to change the database schema with upgrades.
- Select: permission to read the records from the tables.
- Drop Table: permission to change the database schema during upgrades and to remove tables from the database while deleting the site.
- Drop Database: permission to drop the database while deleting the site.
Frequently asked questions
Why does Bold Reports® need the Drop Database permission?
Bold Reports® uses the Drop Database permission to drop the database while deleting the site.
Why does Bold Reports® need the Alter permission?
Bold Reports® uses the Alter permission to change the database schema with upgrades.