Groups > comp.databases.postgresql > #828

create user mapping for user_in_postgredb server my_remote_ms_server options (username 'domain\myuser', password 'keepsecret');

Newsgroups	comp.databases.postgresql
Date	2018-05-21 23:32 -0700
Message-ID	<eac5adca-47de-435b-acfb-871feabe7990@googlegroups.com> (permalink)
Subject	create user mapping for user_in_postgredb server my_remote_ms_server options (username 'domain\myuser', password 'keepsecret');
From	bjorn.d.jensen@gmail.com

Show all headers | View raw

Hi!
I have to manage PostgreSQL scripts, that will create
objects (tables, views, functions etc), including
foreign data wrapper.


I have a shell script that will start execution of a couple
of postgresql-script files creating these objects.

One of the script files includes code like this:


create user mapping for user_in_postgredb server my_remote_ms_server options (username 'domain\myuser', password 'keepsecret');


I don't like the idea having the password in clear text as part of the script
files stored in GIT repository accessbile by non-db-admins.

How to avoid this?

BR
Bjorn

Back to comp.databases.postgresql | Previous | Next — Next in thread | Find similar

Thread

create user mapping for user_in_postgredb server my_remote_ms_server options (username 'domain\myuser', password 'keepsecret'); bjorn.d.jensen@gmail.com - 2018-05-21 23:32 -0700
  Re: create user mapping for user_in_postgredb server my_remote_ms_server options (username 'domain\myuser', password 'keepsecret'); Laurenz Albe <laurenz@nospam.pn> - 2018-05-22 11:27 +0000
  Re: create user mapping for user_in_postgredb server my_remote_ms_server options (username 'domain\myuser', password 'keepsecret'); mattheww@chiark.greenend.org.uk (Matthew Woodcraft) - 2018-05-22 18:07 +0100
    Re: create user mapping for user_in_postgredb server my_remote_ms_server options (username 'domain\myuser', password 'keepsecret'); bjorn.d.jensen@gmail.com - 2018-05-23 08:53 -0700

csiph-web