| From: | M Sarwar <sarwarmd02(at)outlook(dot)com> |
|---|---|
| To: | Krishna B <krishnasvkb(at)gmail(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Login script |
| Date: | 2023-12-21 20:05:55 |
| Message-ID: | DM4PR19MB59784655F4121D74E41C6B3DD395A@DM4PR19MB5978.namprd19.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(at)gmail(dot)com>
Sent: Thursday, December 21, 2023 2:41 PM
To: pgsql-admin(at)lists(dot)postgresql(dot)org <pgsql-admin(at)lists(dot)postgresql(dot)org>
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2023-12-21 20:08:27 | Re: Case sensitive grant statements in pg14? |
| Previous Message | M Sarwar | 2023-12-21 20:03:05 | Re: Case sensitive grant statements in pg14? |