palCentre is the software for entering and managing data relating to PCOC (Palliative Care Outcomes Collaboration). PCOC is a national palliative care outcomes and benchmarking program. PCOC’s primary objective is to systematically improve patient outcomes (including pain and symptom control). For more information on the dataset collected please see our the PCOC data dictionary. For more information on how the data is used, please see our the PCOC data policy.
The palCentre software is replacing SNAPshot which is the original software used for PCOC data entry.
...
As already mentioned palCentre uses SQL Logins to authenticate to the database. It requires 3 logins to exist, and they are created and mapped to database users in the palCentre database by the configuration wizard. The next table describes the logins, their purpose and the user roles which use them (user roles are explained in the next section – Application Level Security)
Login Name | Example | SQL Server Database Roles | User Roles (Application) |
{prefix}_dbo | palCentre_dbo | dbo | Administrator |
{prefix}_user | palCentre_user | db_datareader db_datawriter | Manager User |
{prefix}_reader | palCentre_reader | db_datareader | Reader |
The purpose of having different levels of users access the database with different SQL Logins is to add security. It makes it literally impossible for a user logged in with the Application Role of ‘Reader’ to alter data, and ensures that only a user logged with the Application Role of ‘Administrator’ could ever make changes to database structure. It also means that from the outset, the business engine of palCentre is designed to be able to be used safely by both a Windows Application and potentially in the future, a web application.
...