Vault Postgres ERROR: permission denied for relation

[aa60...@gmail.com]

My vault config:

   

    vault write database/config/demo \
    plugin_name="postgresql-database-plugin" \
    allowed_roles="*" \
    connection_url="postgresql://postgres:pgp...@xxx.xxx.xxx.xxx:5432/postgres

I’ve created role:

   

    vault write database/roles/demobase \
    db_name="demo" \
    creation_statements="CREATE ROLE \"{{name}}\" WITH LOGIN PASSWORD '{{password}}' VALID UNTIL '{{expiration}}’ CREATEDB; \
    GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO \"{{name}}\";" \
    default_ttl="1h" \
    max_ttl="24h"

and got ERROR:  permission denied for relation

Whats wrong?

[Subodh Joshi]

Issue with db_name ,first you created a config for dbanme="postgres" while you create a role for db_name="demo"