Thread: Default Permissions (repost from Novice)

Default Permissions (repost from Novice)

From
Michael Weaver
Date:
<p><font face="Verdana" size="2">How can I set default permissions on tables, so that I don't have to manually set them
forevery table?</font><p><font face="Verdana" size="1">p.s.</font><br /><font face="Verdana" size="1">This is a re-post
fromthe novice list, I thought it might also be appropriate to ask here.</font><p><font face="Verdana" size="1">MIKE
WEAVER<b><br/> Software Developer</b><br /><br /> 5, 42 Ladner Street<br /> O'Connor, WA, 6163</font><br /><b><font
face="Verdana"size="1">All correspondence:</font></b><br /><font face="Verdana" size="1">PO Box Y3502<br /> East St
GeorgesTerrace<br /> Perth WA 6832<br /><br /> P: (+618) 9331 2700<br /> F: (+618) 9331 3733<br /> M: 0419 299 170<br
/>W:<u> </u></font><u><font color="#0000FF" face="Verdana" size="1"><a href="http://www.corpusglobe.com/"
target="_blank">http://www.corpusglobe.com/</a></font></u><fontface="Verdana" size="1"><br /> E:</font><u> <font
color="#0000FF"face="Verdana" size="1">mweaver@corpusglobe.com</font></u><p align="CENTER"><font face="Verdana"
size="1">Thisemail is intended only for the use of the individual or entity named above and may contain information
thatis confidential. If you are not the intended recipient, you are hereby notified that any dissemination,
distributionor copying of this email is strictly prohibited. When addressed to our clients, any opinions or advice
containedin this email are subject to the terms and conditions expressed in the governing Corpus Globe client
engagementletter. If you have received this Email in error, please notify us immediately by return email or telephone
+618 9331 2700 and destroy the original message. Thank You. </font><br /><br /> 

Re: Default Permissions (repost from Novice)

From
Richard Huxton
Date:
On Monday 09 Dec 2002 6:51 am, Michael Weaver wrote:
> How can I set default permissions on tables, so that I don't have to
> manually set them for every table?

Don't know if you got an answer in novice, but your best bet is one of the
GRANT ... TO ALL type solutions mentioned in the last week or so. See my
PostgreSQL Notes linked to from http://techdocs.postgresql.org

--  Richard Huxton