All Syncsort Capacity Management applications connect directly to access the Capacity Database via Windows authentication to SQL Server. Syncsort Capacity Management users therefore need permission to connect this way to SQL Server. This is achieved by granting SQL Server logons to Windows user or group accounts. The permissions that a user or group possesses are defined by assigning the SQL Server logon to one or more roles. There are SQL Server roles that define permissions at the SQL Server instance level, and database roles that define permissions at the database level.
There are two database roles defined in a Capacity Database to simplify configuring permissions to the database. These are named AtheneDbUser and AtheneDbWriter.
There are various levels of permissions required, depending on the user task. The following table gives examples of the SQL Server permissions required based on SQL.
|