From: Scott Ribe <scott_ribe@elevated-dev.com>
To: pavan95 <pavan.postgresdba@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Granting any privilege for a specific set of tables in postgres in a single shot!..
Date: Wed, 25 Jul 2018 07:41:52 -0600
Message-ID: <84DC1576-3D76-40B9-83D5-F6579B62F264@elevated-dev.com> (raw)
In-Reply-To: <1532525538301-0.post@n3.nabble.com>
References: <1532525538301-0.post@n3.nabble.com>
3 suggestions
- use roles so you don't have to grant to so many individual users
- use schemas so you don't have to grant to individual tables
- select 'grant select on ' || ? || ' to ' || ?, into a script which you then execute
--
Scott Ribe
scott_ribe@elevated-dev.com
https://www.linkedin.com/in/scottribe/> On Jul 25, 2018, at 7:32 AM, pavan95 <pavan.postgresdba@gmail.com> wrote:
>
> Hi all,
>
> Hope my mail finds you in good time. I have a question in regards to
> "Grant" command.
>
> How can I grant a particular privilege to a specific set of objects(tables)
> in a single shot ?
>
> FYI, please consider the following scenario. I have a database "abc" with
> users as "u1","u2","u3","u4". And there are 1500 tables in my database.
>
> Now my requirement is to grant select on 800 tables(specific set of tables)
> which suits my requirement. I know that I can use the below statement 800
> times.
>
> grant select on table1 to u1;
> grant select on table2 to u1;
> .
> .
> .
> .
> .
> .
> grant select on table800 to u1;
>
> My question is can't I do it in a single shot? Can I fit some select query
> which passes the table name as a parameter in the middle of the grant
> statement?
>
> Please advice.
>
> Thanks in Advance.
>
> Regards,
> Pavan
>
>
>
>
>
> --
> Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, pavan.postgresdba@gmail.com
Subject: Re: Granting any privilege for a specific set of tables in postgres in a single shot!..
In-Reply-To: <84DC1576-3D76-40B9-83D5-F6579B62F264@elevated-dev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox