CA IT Asset ManagerCA Software Asset Manager (CA SAM)ASSET PORTFOLIO MGMT- SERVERCA Service Management - Asset Portfolio ManagementCA 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.