pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Granting select on ALL tables at once
2+ messages / 2 participants
[nested] [flat]

* Granting select on ALL tables at once
@ 1999-05-04 00:04  G. Anthony Reina <reina@nsi.edu>
  0 siblings, 0 replies; 2+ messages in thread

From: G. Anthony Reina @ 1999-05-04 00:04 UTC (permalink / raw)
  To: pgsql-sql

Is there a way to grant a select to a user on all tables. So far, I've
only been able to do this table by table.


Thanks.
-Tony





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* RE: [SQL] Granting select on ALL tables at once
@ 1999-05-04 05:52  Michael J Davis <michael.j.davis@tvguide.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Michael J Davis @ 1999-05-04 05:52 UTC (permalink / raw)
  To: 'G. Anthony Reina' <reina@nsi.edu>; pgsql-sql

I use the following technique a lot:

-- create a file containing a bunch of grant commands
\g grant_all.sql
select (('GRANT ALL ON ' || relname) || ' TO PUBLIC;') as "-- grant" 
    FROM pg_class WHERE relkind = 'r' and substr(relname,1,3) <> 'pg_'
    order by relname;  -- table and views
\g
-- execute the file of grant commends
\i grant_all.sql


	-----Original Message-----
	From:	G. Anthony Reina [SMTP:reina@nsi.edu]
	Sent:	Monday, May 03, 1999 6:05 PM
	To:	pgsql-sql@postgreSQL.org
	Subject:	[SQL] Granting select on ALL tables at once

	Is there a way to grant a select to a user on all tables. So far,
I've
	only been able to do this table by table.


	Thanks.
	-Tony

	



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1999-05-04 05:52 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-05-04 00:04 Granting select on ALL tables at once G. Anthony Reina <reina@nsi.edu>
1999-05-04 05:52 RE: [SQL] Granting select on ALL tables at once Michael J Davis <michael.j.davis@tvguide.com>

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