Gonzalo Vasquez gvasquez95

## bucket-policy.json
{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Sid": "AddPermStaticsAXK",
            "Effect": "Allow",
            "Principal": "*",
            "Action": "s3:GetObject",
            "Resource": "arn:aws:s3:::<my-bucket-fqdn>/*",
            "Condition": {

## FullSizeRender.jpg

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                gvasquez95
                / FullSizeRender.jpg
            
            
              Last active
              July 1, 2018 01:58
            
              
                ACloud.guru Certified Solutions Associate Course on iPhone shows Certified Developer Associate related content
              
          
## disable_triggers.sql
SQL:
SELECT 'ALTER TABLE '
       || table_name
       || ' DISABLE TRIGGER ALL;'
FROM   information_schema.TABLES
WHERE  table_catalog = 'waypoint';

OUTPUT ROWS:

ALTER TABLE pg_type DISABLE TRIGGER ALL;
	{
	"Version": "2012-10-17",
	"Statement": [
	{
	"Sid": "AddPermStaticsAXK",
	"Effect": "Allow",
	"Principal": "*",
	"Action": "s3:GetObject",
	"Resource": "arn:aws:s3:::<my-bucket-fqdn>/*",
	"Condition": {
	SQL:
	SELECT 'ALTER TABLE '
	\|\| table_name
	\|\| ' DISABLE TRIGGER ALL;'
	FROM information_schema.TABLES
	WHERE table_catalog = 'waypoint';

	OUTPUT ROWS:

	ALTER TABLE pg_type DISABLE TRIGGER ALL;