(AI KB) PCS: SQL Security Roles for Setup

Below outlines the necessary SQL permissions required for PCS for users and for PCS Job Services, based on their role (determined by their organization/business).

Read-Only Access

• AXIS_Users
• db_datareader
• VIEW_SERVER_STATE
• public

General Users Access

• AXIS_Users
• db_datareader
• db_datawriter
• VIEW_SERVER_STATE
• public

PCS Admin Access

• AXIS_Users
• db_datareader
• db_datawriter
• db_ddladmin
• db_owner
• VIEW_SERVER_STATE
• public

PCS Job Services

• AXIS_Users
• db_datareader
• db_datawriter
• db_ddladmin
• db_owner
• VIEW_SERVER_STATE
• public