2008/12/11 TiTo(R) <t...@uel.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
