Re: [HACKERS] Here it is - view permissions

On Mon, 23 Feb 1998, Jan Wieck wrote:

> > >     include/utils/acl.h line 65
> > >
> > >     set ACL_WORLD_DEFAULT to ACL_NO
> > >
> > >     Then tables and views default to what you wanted.
> >
> >     Have you actually tried this? :)  Does it break anything?
> >
> >
> >
>
>     No I didn't - but if I read your smiley correct it does - right?

    Only too well :)

    If I enable this, a \d no longer works as anyone but superuser,
with the first error being:

ERROR: pg_class: Permission denied.

    So it hits all the system tables too...

    Which wouldn't be too bad, just a matter of doing a 'GRANT SELECT'
from inside of initdb to get around this...

    ...except, doing 'GRANT SELECT on pg_class to public' causes a
'PQexec() -- Request was sent to backend, but...' error message, and a
'Failed Assertion' on file inval.c...

    I'm not going to get a chance to investigate this during the day
today, so if anyone else wants to look into it?  If not, I'll look at it
from home tonight and see if I can figure it out...