Dick Kniep <[EMAIL PROTECTED]> writes:
> Now when I try to access the tables/views in the schema as a user that
> is NOT a member of the group adeuxproductie, I expect it to
> fail. However, access is granted as if there is no authorization
> specified.
Perhaps you tested this as a superuser? For
OK, that's cleared, thanks,
Now another question related to this. In 7.4.8 I have a schema with the
following authorization:
CREATE SCHEMA adeuxproductie
AUTHORIZATION postgres;
GRANT ALL ON SCHEMA adeuxproductie TO postgres;
GRANT ALL ON SCHEMA adeuxproductie TO GROUP adeuxproductie;
COMMENT
On Tue, Mar 28, 2006 at 09:41:46AM +0200, Dick Kniep wrote:
> Hi list,
>
> We have developed a system that is running as an ASP application, currently
> we
> are using Postgresql 7.4. For every customer we have a separate schema, and
> this works OK. Now in version 8, tablespaces were introduce
Hi list,
We have developed a system that is running as an ASP application, currently we
are using Postgresql 7.4. For every customer we have a separate schema, and
this works OK. Now in version 8, tablespaces were introduced. This summer we
are planning to migrate to version 8.1. Question is if
