There are many requirements for data to be written to the Capacity Database, for example: configuring targets in the System Manager, Control Center Service, Job Scheduler, and Data Management.
If you wish to assign the AtheneDbWriter database role to a user it can be done using SQL Server Management Studio, or with the T-SQL script provided below.
USE [DatabaseName] EXEC ap_s_AddWriter [DomainName\UserName]