Re: [GENERAL] Alter Default Privileges Does Not Work For Functions

2011-02-14 Thread David Johnston
g the problem. Thanks again for helping me get my head around some of this stuff. David J -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Monday, February 14, 2011 7:05 PM To: David Johnston Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Alter Default Privileges

Re: [GENERAL] Alter Default Privileges Does Not Work For Functions

2011-02-14 Thread Tom Lane
"David Johnston" writes: > After creating and logging into a new database run this script. The > initial ALTER DEFAULT PRIVILEGES should make all users unable to execute > functions unless given explicit permissions elsewhere. You haven't read the fine manual very closely. It saith De

[GENERAL] Alter Default Privileges Does Not Work For Functions

2011-02-14 Thread David Johnston
After creating and logging into a new database run this script. The initial ALTER DEFAULT PRIVILEGES should make all users unable to execute functions unless given explicit permissions elsewhere. However, the first call to "testfunc()" succeeds. When I explicitly REVOKE ALL for the specific fun