No PUBLIC access by default?

[Peter Fein <pfein@xxxxxxxxx>]

Hi all-

Is there any way to disable PUBLIC access by default?  When I create a
new object (table, function, etc.), it has no ACL, as expected.
However, the first time I run:

GRANT ALL ON FUNCTION foo() to GROUP developers;

Postgress seems to do:

GRANT ALL ON FUNCTION foo() to PUBLIC;

I assume this is b/c no ACL is equivalent to PUBLIC access & this gets
included when adding specific privileges.

I want *no* PUBLIC access to anything by default for security reasons.
Is there a way to prevent this behavior?

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org