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(at)gmail(dot)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
>
>