I use vault to generate users on Postgres, Redshift. In postgres and redshift I have predefined groups with permissions (ro/rw) and I want to add the users created by Vault to the corresponding group. I tried using
in postgres:
CREATE USER \"{{username}}\" WITH PASSWORD '{{password}}' IN GROUP {group_name}'
in redshift
'CREATE USER \"{{username}}\" WITH PASSWORD '{{password}}' VALID UNTIL '{{date}}'; ALTER GROUP {group_name} ADD USER \"{{username}}\";'
with out any luck… it generates error messages of encoding.
what’s the best practice for such case? as per the Vault instance - it’s a fargate cluster and I don’t have direct access to it… 