From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
---|---|
To: | Jan Wieck <jwieck(at)debis(dot)com> |
Cc: | PostgreSQL HACKERS <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Re: [HACKERS] Here it is - view permissions |
Date: | 1998-02-23 15:30:19 |
Message-ID: | Pine.NEB.3.95.980223102654.17896J-100000@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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...
From | Date | Subject | |
---|---|---|---|
Next Message | Darren King | 1998-02-23 15:31:04 | ecpg glitches in Feb 23rd beta. |
Previous Message | Andrew Martin | 1998-02-23 15:20:41 | Re: [HACKERS] Open 6.3 issues |