What SQL rights or database permissions are needed for the Application Identity (App ID), service account, or SQL account?
The following content applies to Notification Server or Symantec Management Platform versions 8.x and later versions.
Minimum SQL Security Requirements
The account that Notification Server uses to access the SQL database needs to be able to do the following:
Additionally, this account needs to:
The Notification Server user account will need “dbcreator” permissions in order for the Notification Server installation process to create the Symantec_CMDB Database. If the SQL administrator creates the Symantec_CMDB Database prior to Notification Server installation, then this permission is not necessary; just point the installation process to the already present Symantec_CMDB Database.
On the Symantec_CMDB Database itself, the user will need the following permissions:
Additionally, when the Symantec Installation Manager (SIM) is installing SMP; If the Altiris database does not already exist, then this account needs to be able to create the Altiris database.
To verify that the Application Identity is DBO on the database, run the following SQL command as the Application Identity account: