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!
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@xxxxxxxxx>, 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 youKris k