CA SAM User - Database User Permissions

Article Id: 76479

Status: Published

Updated On: 04-04-2018 09:32

Products:

CA IT Asset Manager , CA Software Asset Manager (CA SAM) , ASSET PORTFOLIO MGMT- SERVER , CA Service Management - Asset Portfolio Management , CA Service Management - Service Desk Manager

Issue/Introduction:

Currently the database account has sysadmin and dbo access to the database and the DBA teams wants to remove both.
Are either privileges needed to run and upgrade CA SAM?

Environment:

CA Software Asset Manager 4.x

Resolution:

The CA SAM user created during the install does NOT need sysadmin privileges; however, dbowner permissions is needed for a CA SAM upgrade.