Read all data (tables, views, sequences), as if having SELECT rights on those objects, and USAGE rights on all user-created schemas.
- Replace
db_name
with the relevant database name. - Run the
Database
section of the script.
<div [formGroup]="form"> | |
<input placeholder="Course title" formControlName="title"> | |
<input type="checkbox" placeholder="Free course" formControlName="free"> | |
<textarea placeholder="Description" formControlName="longDescription"> | |
</textarea> | |
Read all data (tables, views, sequences), as if having SELECT rights on those objects, and USAGE rights on all user-created schemas.
db_name
with the relevant database name.Database
section of the script.-- (Optional) Change password to something unknown to the user | |
ALTER user my_user WITH PASSWORD 'delete-me'; | |
-- Shift ownership of objects to another user | |
REASSIGN OWNED BY my_user TO postgres; | |
-- Drop any privledges granted to the user (not sure why this isn't done automatically) | |
DROP OWNED BY my_user; | |
-- Drop the user |
Run this with the aws cli
for lb_arn in $(aws elbv2 describe-load-balancers --query 'LoadBalancers[*].LoadBalancerArn' --output text); do aws elbv2 describe-listeners --load-balancer-arn $lb_arn --query 'Listeners[].[LoadBalancerArn,Protocol,SslPolicy]' --output text; done
Sample output: arn:aws:elasticloadbalancing:us-east-1:12341234:loadbalancer/app/good-elb/1234asdf1234asdf HTTPS ELBSecurityPolicy-TLS-1-2-2017-01 arn:aws:elasticloadbalancing:us-east-1:12341234:loadbalancer/app/good-elb/1234asdf1234asdf HTTP None