Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

question/problem concerning GRANT/REVOKE



hi!

I have a pretty basic problem: We have several schemas in one of our databases, and we need the users to see only the tables (and table structure) of tables inside their own schema. So I created schemas for those users, and set their "search_path".

But with \d public.<tab key> users can see all tables (and their structure) in the public (and other) schemas -- and I found no way yet to prevent this?? I have tried "REVOKE ALL" from the database itself, and the other schemas, and single tables -- for the specific user, and also for the user "PUBLIC" -- but it had no effect! How can I prevent exposing the structure of all tables in the database to user that should work in their SCHEMA?

Help would be appreciated very much!! :-)

cheers,
gerhard



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group