Thread: Set Privileges on All Tables (and/or Sequences) at Once
Set Privileges on All Tables (and/or Sequences) at Once Can this be done? or am i stuck doing this on each table and sequence whenever i create a new group? tia... __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com
On 10/7/05 1:20 PM, "operationsengineer1@yahoo.com" <operationsengineer1@yahoo.com> wrote: > Set Privileges on All Tables (and/or Sequences) at > Once > > Can this be done? or am i stuck doing this on each > table and sequence whenever i create a new group? > > tia... See here: http://archives.postgresql.org/pgsql-novice/2005-10/msg00018.php Sean
On Oct 7, 2005, at 1:20 PM, <operationsengineer1@yahoo.com> <operationsengineer1@yahoo.com> wrote: > Set Privileges on All Tables (and/or Sequences) at > Once > > Can this be done? or am i stuck doing this on each > table and sequence whenever i create a new group? There are some functions here which can do this for you en masse. http://pgedit.com/node/20 John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL
The pgAdmin III application allows for this. Try http://www.pgadmin.org/ Derrick ----- Original Message ----- From: <operationsengineer1@yahoo.com> To: <pgsql-novice@postgresql.org> Sent: Friday, October 07, 2005 11:20 AM Subject: [NOVICE] Set Privileges on All Tables (and/or Sequences) at Once > Set Privileges on All Tables (and/or Sequences) at > Once > > Can this be done? or am i stuck doing this on each > table and sequence whenever i create a new group? > > tia... > > > > __________________________________ > Yahoo! Mail - PC Magazine Editors' Choice 2005 > http://mail.yahoo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > >