CA SAM User - Database User Permissions

Document ID : KB000076479
Last Modified Date : 04/04/2018
Show Technical Document Details
Question:

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
Answer:
The CA SAM user created during the install does NOT need sysadmin privileges; however, dbowner permissions is needed for a CA SAM upgrade.