pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedGRANT ON all tables
2+ messages / 2 participants
[nested] [flat]
* GRANT ON all tables
@ 2004-08-27 15:30 Nosyman <nosyman@easymail.ro>
0 siblings, 1 reply; 2+ messages in thread
From: Nosyman @ 2004-08-27 15:30 UTC (permalink / raw)
To: pgsql-sql
Hi there,
I need to know how can I give privileges to all the tables in a database.
For example, I have one database named "test" .This database contains about
30 tables. I want to grant SELECT and DELETE privileges to the 'test_user'
by typing GRANT .... just once (something like GRANT SELECT, DELETE ON
all_tables TO test_user). It is possible? I search PostgreSQL docs and I
can't find out...
Thanks
Nosy
_________________________________________________________________
Message
sent using ITCNet free webmailer (http://www.easymail.ro)
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: GRANT ON all tables
@ 2004-08-27 19:20 Bruno Wolff III <bruno@wolff.to>
parent: Nosyman <nosyman@easymail.ro>
0 siblings, 0 replies; 2+ messages in thread
From: Bruno Wolff III @ 2004-08-27 19:20 UTC (permalink / raw)
To: Nosyman <nosyman@easymail.ro>; +Cc: pgsql-sql
On Fri, Aug 27, 2004 at 15:30:32 -0000,
Nosyman <nosyman@easymail.ro> wrote:
> Hi there,
>
> I need to know how can I give privileges to all the tables in a database.
> For example, I have one database named "test" .This database contains about
> 30 tables. I want to grant SELECT and DELETE privileges to the 'test_user'
> by typing GRANT .... just once (something like GRANT SELECT, DELETE ON
> all_tables TO test_user). It is possible? I search PostgreSQL docs and I
> can't find out...
There is no command to do this. You can write a script that queries
the information schema and then issues a grant command for each table.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-08-27 19:20 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-27 15:30 GRANT ON all tables Nosyman <nosyman@easymail.ro>
2004-08-27 19:20 ` Bruno Wolff III <bruno@wolff.to>
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