Hi Sarwar,
I am using pgadmin tool..
Thank you
Krishna B
On Thu, Dec 21, 2023 at 8:52 PM M Sarwar <sarwarmd02@xxxxxxxxxxx> wrote:
Hello Krishna,
Which Editor you are referring in your email?Actually, I am trying to use such Editor. Currently I am using pgAdmin and SQL- Developer to connect Postgres databases but the editor features which are available are not meeting the demands. I am just trying to know if you are using any other editor from any other tools or using any other way.
>From PSql, we can only run SQL queries to get the desired results.For example, if I click on the user or table in the editors, I want to fetch all the SQLs related all privilege assignments on that object. This is not my just theory but I worked on this type of environment in the past and now I missing them.
Thank you,Sarwar
From: SOzcn <selahattinozcnma@xxxxxxxxx>
Sent: Thursday, December 21, 2023 3:23 PM
To: Krishna B <krishnasvkb@xxxxxxxxx>
Cc: pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: Re: Login scriptHello,
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
