MongoDB

MongoDB

Overview

• Self Service Access - Empower your developers to gain self-servable access to databases using Slack.

• Automated Approval Workflows - Create approval workflows to specific sensitive databases.

• Restricted Third Party Access - Grant third-party (customer or vendor) time-based access to specific databases with MFA verification.

• Review Access - View a detailed access audit of who was granted access to which databases with what permission level and why.

Step by step guide

How to Integrate MongoDB

Creating a user

Apono requires a user in the DB instance so it can provision.

1. In MongoDB, switch to admin database

   Copy

   use admin;

2. Create a user for Connector in the instance, and type the password to the apono-connector user.(password)

   Copy

   db.createUser({
       user: "apono-connector",
       pwd: "password",
       roles: [
           {
               "role" : "clusterMonitor",
               "db" : "admin"
           },
           {
               "role" : "userAdminAnyDatabase",
               "db" : "admin"
           },
           {
               "role" : "readWriteAnyDatabase",
               "db" : "admin"
           },
           {
               "role" : "clusterManager",
               "db" : "admin"
           }
       ]
   });

3. Storing the secret in your environment secret store.

aws secretsmanager create-secret --name "#SECRET_NAME" --tags '[{"Key":"apono-connector-read","Value":"true"}]' --region #REGION --secret-string '{
    "username":"'"apono-connector"'",
    "password":"'"#PASSWORD"'"
}'

Connecting to Apono

1. Open Integrations Catalog

2. Click on MongoDB integration card

3. Select the Connector, this is the Connector which is installed in the same AWS account as the MongoDB instance

4. Type in a friendly name for the integration

5. Fill in the hostname and port

Assign the Secret

AWS

Use the respective secret which was stored in AWS Secret Manager previously in this guide.

• Select the secret from the Secret Manager according to the appropriate AWS account and region

1. Click Create

Creating a user

Connector requires to have a user in the DB instance so it can provision access. Provisioning is done by creating an admin user in the database.

1. In MongoDB, switch to admin database

   Copy

   use admin;

2. Create user for Connector in the instance, type in some secure password

   Copy

   db.createUser({
       user: "apono-connector",
       pwd: "password",
       roles: [
           {
               "role" : "clusterMonitor",
               "db" : "admin"
           },
           {
               "role" : "userAdminAnyDatabase",
               "db" : "admin"
           },
           {
               "role" : "readWriteAnyDatabase",
               "db" : "admin"
           },
           {
               "role" : "clusterManager",
               "db" : "admin"
           }
       ]
   });

3. Using aws-cli, store in AWS Secret Manager, make sure to replace #SECRET_NAME,#REGION, #PASSWORD

   Copy

   aws secretsmanager create-secret --name "#SECRET_NAME" --tags '[{"Key":"apono-connector-read","Value":"true"}]' --region #REGION --secret-string '{
       "username":"'"apono-connector"'",
       "password":"'"#PASSWORD"'"
   }'