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.