...
Create a user (datical_user) for database where Packager operation Forecast and Deploy (not Packager) operations will be performed:
Role/Permission | When is this required? | Permissions |
|---|---|---|
db_ddladmin | This is required if you do not connect as the database owner. | Run any Data Definition Language (DDL) command in a database. |
db_datawriter | This is required if you do not connect as the database owner. | Add, delete, or change data in all user tables. |
db_datareader | This is required if you do not connect as the database owner. | Read all data from all user tables. |
VIEW DATABASE STATE | This is required for some Datical operations such as using Approximate Row Counts. | Read data from dynamic management views scoped to the database. |
...