The permissions that are applied to users trying to access a SQL Server database can be critical.

 

As a guideline, we suggest the following:

 

1.For regular users, FCS Express will require that the users have SELECT,UPDATE,INSERT, and DELETE permissions.

 

a)Since there is not a defined role within SQL Server that contains the SELECT,UPDATE,INSERT, and DELETE permissions together, regular users can use both the db_datareader and db_datawriter roles to give those permissions.

b)db_datareader includes the SELECT permission.

c)db_datawriter includes the UPDATE,INSERT, and DELETE permissions.

 

 

2.For admin users that need to perform upgrades, the user will need the full CONTROL permission on the FCS Express security database. An example of a role that gives this permission is the db_owner role.

 

 

A summary of the various MS SQL Server roles and the permissions that are defined for those roles can be found on the Microsoft web site at https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2005/ms189612%28v%3dsql.90%29.