Re: [HACKERS] Here it is - view permissions - Mailing list pgsql-hackers

From The Hermit Hacker
Subject Re: [HACKERS] Here it is - view permissions
Date
Msg-id Pine.NEB.3.95.980223102654.17896J-100000@hub.org
Whole thread Raw
In response to Re: [HACKERS] Here it is - view permissions  (jwieck@debis.com (Jan Wieck))
List pgsql-hackers
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...



pgsql-hackers by date:

Previous
From: Andrew Martin
Date:
Subject: Re: [HACKERS] Open 6.3 issues
Next
From: Brook Milligan
Date:
Subject: [teo@flex.ro: [QUESTIONS] New version of PgAccess released - 0.80]