Adding groups or users to your RDS database (AWS)

We recommend adding groups / users to your Relational Database Service (RDS) database using the Harmony Database Manager:

Launch the Harmony Database Manager.

The Harmony Database Manager utility opens.

Click the Add Users and Groups tab.

In the Connect to Database section, type the credentials you want to use to connect to the database. This account must have access to the database and have permission to add users to the database.

In the Add Users or Groups section, specify the authentication type for the group(s) or user(s) to be added. Note that the Harmony Database Manager adds both a login for the server, and a user associated with that login for the database with the same name. If a login already exists, the utility skips creating a user and attempts to add the user to the required database roles. If the user is orphaned (does not have a login associated with it), the utility attempts to reconnect the user to the login.

a. If you want to add Active Directory (AD) users, select Windows Authentication.

b. if you want to add SQL users, Select SQL Server Authentication.

Specify the Username / Group. (Make sure to include the AD domain name, if you selected Windows Authentication.)

Click Add Users.

A login for the server and a user for the database is created with the proper roles to access the database through Harmony Enterprise.