aws-bipost-cloudformation/test-dbpolicy.template at master · factorbi/aws-bipost-cloudformation · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
{
  "AWSTemplateFormatVersion": "2010-09-09",
  "Description": "RDS Policy for Aurora Cluster",
  "Parameters": {
    "BucketName": {
      "Description": "Bucket name provided by Factor BI",
      "Type": "String",
      "AllowedPattern": "[a-zA-Z][a-zA-Z0-9-]*",
      "ConstraintDescription": "Insert bucket name"
    }
  },
  "Resources": {
    "DBRole": {
      "Type": "AWS::IAM::Role",
      "Properties": {
        "Path": "/",
        "AssumeRolePolicyDocument": {
          "Version": "2012-10-17",
          "Statement": [
            {
              "Effect": "Allow",
              "Principal": {
                "Service": "rds.amazonaws.com"
              },
              "Action": [
                "sts:AssumeRole"
              ]
            }
          ]
        },
        "Policies": [
          {
            "PolicyName": "bipostRDStoS3",
            "PolicyDocument": {
              "Statement": [
                {
                  "Effect": "Allow",
                  "Action": [
                    "s3:ListBucket",
                    "s3:GetObject*",
                    "s3:PutObject*",
                    "s3:DeleteObject*",
                    "s3:ObjectOwnerOverrideToBucketOwner"
                  ],
                  "Resource": [
                    {
                      "Fn::Join": [
                        "",
                        [
                          "arn:aws:s3:::",
                          {
                            "Ref": "BucketName"
                          }
                        ]
                      ]
                    },
                    {
                      "Fn::Join": [
                        "",
                        [
                          "arn:aws:s3:::",
                          {
                            "Ref": "BucketName"
                          },
                          "/*"
                        ]
                      ]
                    }
                  ]
                },
                {
                  "Effect": "Allow",
                  "Action": "lambda:InvokeFunction",
                  "Resource": "arn:aws:lambda:us-east-1:951464950892:function:bipost-getOutData"
                }
              ]
            }
          }
        ]
      }
    },
  },
  "Outputs": {
    "DBRole": {
      "Description": "IAM Role to allow Aurora to s3",
      "Value": {
        "Ref": "DBRole"
      }
    },
    "Bucket": {
      "Description": "Bucket name to use on biPost.exe Windows program",
      "Value": {
        "Ref": "BucketName"
      }
    }
  }
}