Month: January 2021

Permanently deleting objects from a s3 bucket that has versioning enabled – not so straight forward

Do NOT use this procedure if you have files in your versioning enabled bucket that you want to keep. The following procedure will permanently delete all files and versions in a bucket. It was written to be run from Linux/Bash and it assume python3 is installed, and the boto3 package is installed remove-all-versions.bash #! /bin/bash …

Permanently deleting objects from a s3 bucket that has versioning enabled – not so straight forward Read More »

Migrating to AWS Cloud? You may want to look at AWS Cloud Adoption Framework

Migrating to AWS Cloud? You may want to look at: AWS Cloud Adoption Framework https://aws.amazon.com/professional-services/CAF/ This framework is delivered with details at a perspective level: Business Perspective People Perspective Governance Perspective Platform Perspective Security Perspective Operations Perspective Resources Perspective Here’s a white paper on the Security Perspective (only): https://d1.awsstatic.com/whitepapers/AWS_CAF_Security_Perspective.pdf

Redshift – Give a user access to ALL rows in the pg_catalog views

The following command will allow a user to see ALL rows in pg_catalog views and tables (not just their own).  By default only a super user can see all rows.  This is a way to grant access to all rows without granting superuser. ALTER USER <USERNAME> SYSLOG ACCESS UNRESTRICTED https://docs.aws.amazon.com/redshift/latest/dg/r_ALTER_USER.html The following view will show …

Redshift – Give a user access to ALL rows in the pg_catalog views Read More »