hashicorp / hashicorp/vault-plugin-database-oracle

Windows setup: Create statement did not store with "{{password}}"

Open
#176 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Go
Stars
29
Forks
21
PR merge metrics
No merged PRs in 30d

Description

I build vault-plugin-database-oracle for windows and tried to setup, but I was not able to get the create statement stored correctly. the "" was not stored for the password. Which caused the issue when the dynamic password contains dash (-). Powershell should treat the quotes the same as bash

For example, from powershell
```

PS C:\> vault write database/roles/dev-role `
>> db_name=dev-oracle-database `
>> creation_statements='CREATE USER {{username}} IDENTIFIED BY "{{password}}"; `
>> default_ttl="1h" `
>> max_ttl="24h"

PS C:\> vault read database/roles/dev-role
Key Value
--- -----
creation_statements [CREATE USER {{username}} IDENTIFIED BY {{password}};]
credential_type password
db_name dev-oracle-database
default_ttl 1h
max_ttl 24h
renew_statements []
```

The same vault write works with linux oracle plugin.
```

$ vault read database/roles/dev-role
Key Value
--- -----
creation_statements [CREATE USER {{username}} IDENTIFIED BY "{{password}}"; GRANT CONNECT TO {{username}}; GRANT CREATE SESSION TO {{username}};ALTER USER dev1 GRANT CONNECT THROUGH {{username}};]
credential_type password
db_name dev-oracle-database
default_ttl 1h
max_ttl 24h
renew_statements []
revocation_statements []
rollback_statements []
```

Does anyone know why?

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.