Article

(AI KB) PCS: SQL Security Roles for Setup

By Hector Jimenez Updated

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
Was this article helpful?