Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.postgresql > #828

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

X-Received by 2002:a0c:d8ee:: with SMTP id w43-v6mr14221071qvj.14.1526970762352; Mon, 21 May 2018 23:32:42 -0700 (PDT)
X-Received by 2002:a0c:f70b:: with SMTP id w11-v6mr2539754qvn.2.1526970762237; Mon, 21 May 2018 23:32:42 -0700 (PDT)
Path csiph.com!weretis.net!feeder6.news.weretis.net!feeder.usenetexpress.com!feeder-in1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!x25-v6no2423505qto.0!news-out.google.com!k3-v6ni2196qtj.0!nntp.google.com!x25-v6no2423495qto.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups comp.databases.postgresql
Date Mon, 21 May 2018 23:32:42 -0700 (PDT)
Complaints-To groups-abuse@google.com
Injection-Info glegroupsg2000goo.googlegroups.com; posting-host=193.47.71.253; posting-account=kvlqsgoAAAB9jMpPa6Isl9p3pKZp08y7
NNTP-Posting-Host 193.47.71.253
User-Agent G2/1.0
MIME-Version 1.0
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
Injection-Date Tue, 22 May 2018 06:32:42 +0000
Content-Type text/plain; charset="UTF-8"
Lines 21
Xref csiph.com comp.databases.postgresql:828

Show key headers only | 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 | NextNext 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