Search Postgresql Archives

Re: Schemas and Privileges

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





2008/12/11 TiTo® <tito@xxxxxx>
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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux