What are the minimum SQL account permissions required for the CA Business Intelligence (CABI) CMS database?


Article ID: 18746


Updated On:


SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager



CABI requires a database to store information about users, groups, security levels, CABI content and servers. This database, which is maintained by the Central Management Server (CMS), is known as the CMS database.

During the CABI installation, you are asked to select a CMS database to connect to. Once you select a CMS database, the CABI setup program creates the tables and views needed to use that database as the system database. During the installation, default servers, users, groups, and content are added to this database.

Prior to the CABI install, the CMS SQL database needs to be created and a SQL user assigned appropriate rights/permissions to the CMS database


The minimum SQL permissions for the SQL account assigned to the CMS database is default database owner (DBO) account permissions, which includes:

  • Permission for the account to create, edit, and drop tables

  • Permission for the account to create stored procedures


Component: SDBOXI