CA SAM User - Database User Permissions

book

Article ID: 76479

calendar_today

Updated On:

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.