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...