Re: Login script

Hi Sarwar,

I am using pgadmin tool..

Thank you
Krishna B

On Thu, Dec 21, 2023 at 8:52 PM M Sarwar <sarwarmd02(at)outlook(dot)com> 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(at)gmail(dot)com>
> *Sent:* Thursday, December 21, 2023 3:23 PM
> *To:* Krishna B <krishnasvkb(at)gmail(dot)com>
> *Cc:* pgsql-admin(at)lists(dot)postgresql(dot)org <pgsql-admin(at)lists(dot)postgresql(dot)org>
> *Subject:* Re: Login script
>
> 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
>
>