Re: Removing {"="} privledges - Mailing list pgsql-general

From Tom Lane
Subject Re: Removing {"="} privledges
Date
Msg-id 26217.1034484257@sss.pgh.pa.us
Whole thread Raw
In response to Re: Removing {"="} privledges  (Martijn van Oosterhout <kleptog@svana.org>)
Responses deferred cascade delete re-check at end of transaction?  (Michael Adler <adler@glimpser.org>)
List pgsql-general
Martijn van Oosterhout <kleptog@svana.org> writes:
> I think the {"="} mean that nobody has permissions (except super
> users).

It means that PUBLIC has no permissions.

> If there is nothing at all if means there are no restrictions

No, that means that the relacl field is NULL, which implies default
permissions, which are typically "all access for owner, no access
for anyone else".

I think this is better explained in the 7.3 GRANT manual page than
it was before.  Robert is probably looking at 6.something docs,
which were pretty poor at explaining GRANT :-(

            regards, tom lane

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Removing {"="} privledges
Next
From: "Brett"
Date:
Subject: Sizing and striping log area