|
Without dropping the schema and recreating the schema, you need to clean /drop all the database objects from the same schema manually if you are looking work without dropping the schema.
Thanks,
Sarwar
From: Krishna B <krishnasvkb@xxxxxxxxx>
Sent: Thursday, December 21, 2023 2:41 PM To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx> Subject: Login script 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
|
