Re: Schemas and Privileges

2008/12/11 TiTo(R) <tito(at)uel(dot)br>

> I installed the Postgres Database on my work planning replace Oracle on
> the new IT systems. I have noticed some differences (between Oracle and
> Posrgres) that I would like clarify.
>
> On postgres, I create 2 users and their schemas. Schema "User1" owned by
> "User1" and Schema "User2" owned by "User2". User2 can´t access,
> by 'select', data from tables in schema User1, that is OK, but the User2 can
> display columns from tables in schema User1. I tried the commands "REVOKE
> ALL ON SCHEMA User1 FROM User2" and "REVOKE ALL ON SCHEMA User1 FROM
> public" but, they change nothing.
>
> On Oracle, the user can see the tables columns in others schemas when it
> has "grant" on the table. If user dont have grant on table, it can´t display
> the table columns of others schemas.
>
> Is there something I can do to make postgres works like Oracle ? I am
> using postgres 8.1.11 on SLES10.
>
>

postgres grant model is different; you can't hide db structure from db
users.
only the data is protected.

this is not going to change soon, AFAIK.

--
Filip Rembiałkowski