How to create user level env_var and use it in dbt models?

Help
1

I want set env_var for database connection details at user level and use it in dbt models

Im able to set env_var at user level using [System.Environment]::SetEnvironmentVariable() but not able to refer those variables in profiles.yml. I tried to refer it using jinja macro env_var but its not bale to identify variable.

However if i set same variables at session/process level, Im able to refer it and dbt debug also working OK.

below is the way im referring variable in profiles.yml

password: "{{ env_var('DBT_ORACLE_PASSWORD') }}"