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.
Sérgio Tito
Londrina - Brazil