open id 

HomeInstallation / Setup

Help with Installation and Setup

Minimum DB permissions for SQL install Messages in this topic - RSS

Fresh Cut Grass
Fresh Cut Grass
Posts: 65


4/11/2022
Fresh Cut Grass
Fresh Cut Grass
Posts: 65
Hey Decisions,

What is the lowest permissions levels required to install Decisions via SQL server?
0 link
amber.blanton@decisions.com
amber.blanton@decisions.com
Administrator
Posts: 72


4/11/2022
amber.blanton@decisions.com
amber.blanton@decisions.com
Administrator
Posts: 72
Hey Grass,

The minimum the following roles must be assigned to the database user of the Decisions database:
  • db_datawriter
  • db_datareader
  • db_ddladmin

Our documentation goes into further detail on this setup in the SQL Server Database Permission article.


If needing further information, I also recommend reading Microsoft's documentation on this via their Database-Level Roles- SQL Server article.

I hope this helps!
0 link
amber.blanton@decisions.com
amber.blanton@decisions.com
Administrator
Posts: 72


4/11/2022
amber.blanton@decisions.com
amber.blanton@decisions.com
Administrator
Posts: 72
Hey Grass,

The minimum the following roles must be assigned to the database user of the Decisions database:
  • db_datawriter
  • db_datareader
  • db_ddladmin

Our documentation goes into further detail on this setup in the SQL Server Database Permission article.


If needing further information, I also recommend reading Microsoft's documentation on this via their Database-Level Roles- SQL Server article.

I hope this helps!
0 link






Powered by Jitbit Forum 8.3.8.0 © 2006-2013 Jitbit Software