Обсуждение: 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
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@gmail.com>
Sent: Thursday, December 21, 2023 2:41 PM
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Login script
Sent: Thursday, December 21, 2023 2:41 PM
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.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
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@gmail.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 youKris k
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@gmail.com>
Sent: Thursday, December 21, 2023 3:23 PM
To: Krishna B <krishnasvkb@gmail.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Login script
Sent: Thursday, December 21, 2023 3:23 PM
To: Krishna B <krishnasvkb@gmail.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.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!
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@gmail.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 youKris k
Hi Sarwar,
I am using pgadmin tool..
Thank you
Krishna B
On Thu, Dec 21, 2023 at 8:52 PM M Sarwar <sarwarmd02@outlook.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,SarwarFrom: SOzcn <selahattinozcnma@gmail.com>
Sent: Thursday, December 21, 2023 3:23 PM
To: Krishna B <krishnasvkb@gmail.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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@gmail.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 youKris k
Hi Krishna,
Are you able to find all the privileges and roles assigned to any table when a Table is clicked?
The same way, are you able to see all the roles and privileges of a user when a user is clicked.
When I try or click, I do not see all the roles and the privileges.
Happy Holidays!
Sarwar
From: Krishna B <krishnasvkb@gmail.com>
Sent: Thursday, December 21, 2023 10:45 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: SOzcn <selahattinozcnma@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Login script
Sent: Thursday, December 21, 2023 10:45 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: SOzcn <selahattinozcnma@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: 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@outlook.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,SarwarFrom: SOzcn <selahattinozcnma@gmail.com>
Sent: Thursday, December 21, 2023 3:23 PM
To: Krishna B <krishnasvkb@gmail.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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@gmail.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 youKris k
Nope 👎
On Mon, Dec 25, 2023 at 4:37 PM M Sarwar <sarwarmd02@outlook.com> wrote:
Hi Krishna,Are you able to find all the privileges and roles assigned to any table when a Table is clicked?The same way, are you able to see all the roles and privileges of a user when a user is clicked.When I try or click, I do not see all the roles and the privileges.Happy Holidays!SarwarFrom: Krishna B <krishnasvkb@gmail.com>
Sent: Thursday, December 21, 2023 10:45 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: SOzcn <selahattinozcnma@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Login scriptHi Sarwar,I am using pgadmin tool..Thank youKrishna BOn Thu, Dec 21, 2023 at 8:52 PM M Sarwar <sarwarmd02@outlook.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,SarwarFrom: SOzcn <selahattinozcnma@gmail.com>
Sent: Thursday, December 21, 2023 3:23 PM
To: Krishna B <krishnasvkb@gmail.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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@gmail.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 youKris k
Thank you Krishna!
This is confirming that it is not just my issue.
I need to start and preparing the scripts to address this type of issues.
Sarwar
From: Krishna B <krishnasvkb@gmail.com>
Sent: Monday, December 25, 2023 5:43 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: SOzcn <selahattinozcnma@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Login script
Sent: Monday, December 25, 2023 5:43 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: SOzcn <selahattinozcnma@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Login script
Nope 👎
On Mon, Dec 25, 2023 at 4:37 PM M Sarwar <sarwarmd02@outlook.com> wrote:
Hi Krishna,Are you able to find all the privileges and roles assigned to any table when a Table is clicked?The same way, are you able to see all the roles and privileges of a user when a user is clicked.When I try or click, I do not see all the roles and the privileges.Happy Holidays!SarwarFrom: Krishna B <krishnasvkb@gmail.com>
Sent: Thursday, December 21, 2023 10:45 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: SOzcn <selahattinozcnma@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Login scriptHi Sarwar,I am using pgadmin tool..Thank youKrishna BOn Thu, Dec 21, 2023 at 8:52 PM M Sarwar <sarwarmd02@outlook.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,SarwarFrom: SOzcn <selahattinozcnma@gmail.com>
Sent: Thursday, December 21, 2023 3:23 PM
To: Krishna B <krishnasvkb@gmail.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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@gmail.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 youKris k
Yes pls send me too
On Mon, Dec 25, 2023 at 4:46 PM M Sarwar <sarwarmd02@outlook.com> wrote:
Thank you Krishna!This is confirming that it is not just my issue.I need to start and preparing the scripts to address this type of issues.SarwarFrom: Krishna B <krishnasvkb@gmail.com>
Sent: Monday, December 25, 2023 5:43 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: SOzcn <selahattinozcnma@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Login scriptNope 👎On Mon, Dec 25, 2023 at 4:37 PM M Sarwar <sarwarmd02@outlook.com> wrote:Hi Krishna,Are you able to find all the privileges and roles assigned to any table when a Table is clicked?The same way, are you able to see all the roles and privileges of a user when a user is clicked.When I try or click, I do not see all the roles and the privileges.Happy Holidays!SarwarFrom: Krishna B <krishnasvkb@gmail.com>
Sent: Thursday, December 21, 2023 10:45 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: SOzcn <selahattinozcnma@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Login scriptHi Sarwar,I am using pgadmin tool..Thank youKrishna BOn Thu, Dec 21, 2023 at 8:52 PM M Sarwar <sarwarmd02@outlook.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,SarwarFrom: SOzcn <selahattinozcnma@gmail.com>
Sent: Thursday, December 21, 2023 3:23 PM
To: Krishna B <krishnasvkb@gmail.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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@gmail.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 youKris k
Hello Krishna,
I will be happy to share. I need to start developing in the Postgres now. I have lot of code and information from the other databases as of now.
If you have any specific need immediately, I can work with you or you can check with me on the same email id every couple of months.
Thank you,
Sarwar
From: Krishna B <krishnasvkb@gmail.com>
Sent: Monday, December 25, 2023 6:21 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: SOzcn <selahattinozcnma@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Login script
Sent: Monday, December 25, 2023 6:21 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: SOzcn <selahattinozcnma@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Login script
Yes pls send me too
On Mon, Dec 25, 2023 at 4:46 PM M Sarwar <sarwarmd02@outlook.com> wrote:
Thank you Krishna!This is confirming that it is not just my issue.I need to start and preparing the scripts to address this type of issues.SarwarFrom: Krishna B <krishnasvkb@gmail.com>
Sent: Monday, December 25, 2023 5:43 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: SOzcn <selahattinozcnma@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Login scriptNope 👎On Mon, Dec 25, 2023 at 4:37 PM M Sarwar <sarwarmd02@outlook.com> wrote:Hi Krishna,Are you able to find all the privileges and roles assigned to any table when a Table is clicked?The same way, are you able to see all the roles and privileges of a user when a user is clicked.When I try or click, I do not see all the roles and the privileges.Happy Holidays!SarwarFrom: Krishna B <krishnasvkb@gmail.com>
Sent: Thursday, December 21, 2023 10:45 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: SOzcn <selahattinozcnma@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Login scriptHi Sarwar,I am using pgadmin tool..Thank youKrishna BOn Thu, Dec 21, 2023 at 8:52 PM M Sarwar <sarwarmd02@outlook.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,SarwarFrom: SOzcn <selahattinozcnma@gmail.com>
Sent: Thursday, December 21, 2023 3:23 PM
To: Krishna B <krishnasvkb@gmail.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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@gmail.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 youKris k