There are many requirements for data to be read from the Capacity Database, for example: viewing reports in the Portal, use of Analyst or Automatic Reporting.
If you wish to assign the AtheneDbUser 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_AddUser [DomainName\UserName]