CA SAM User - Database User Permissions
Article ID: 76479
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.
Feedback
Powered by
