Postgres Pro
Downloads
Home   >   mailing lists

Re: Login script - Mailing list pgsql-admin

From SOzcn
Subject Re: Login script
Date
Msg-id CAJyV5AbQaMkN_GG5cmwq5c9W5xSd-iTCEJf1WL6Wmmr=yuv2jw@mail.gmail.com
Whole thread Raw
In response to Login script  (Krishna B <krishnasvkb@gmail.com>)
Responses Re: Login script
List pgsql-admin
Tree view
Hello,

You can have the DDL from editors or in the psql. For users you can get the information from pg_authit
select rolname,rolpassword from pg_authid where rolname='postgres';

Have a nice day!

Krishna B <krishnasvkb@gmail.com>, 21 Ara 2023 Per, 22:42 tarihinde şunu yazdı:
Hi All,

Do We have any script to recreate specific schema users before we start any schema refresh from prod to UAT ? 

I need to script out all logins with permissions and roles assigned to UAT before prod schema refresh…

Thank you 
Kris k 

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Case sensitive grant statements in pg14?
Next
From: "Wetmore, Matthew (CTR)"
Date:
Subject: Case sensitive grant statements in pg14?