Restricting login to a single database only (no visible table spaces, groups or roles)

From: Bryce Nesbitt <bnesbitt(at)bepress(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Restricting login to a single database only (no visible table spaces, groups or roles)
Date: 2010-05-12 20:44:08
Message-ID: AANLkTin9VHYdMkUqJimch55jFmPgws1lWF7WaQDsi68m@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

I have a working setup with pgAdmin III, but wish to restrict my user
more. This user currently logs in to a postgres 8.3 cluster that has 5
databases, but their role only has SELECT on one of the databases.
Yet each time they log in they see all the database names, all the
role names, and all the group names. How can I focus them just a
subset of the tree?

I am reading from: http://www.pgadmin.org/docs/dev/connect.html
"The maintenance DB field is used to specify the initial database that
pgAdmin connects to, and that will be expected to have the pgAgent
schema andadminpack objects installed (both optional)."

When I set "Maintenace DB" to the target database, pgAdmin III comes
up fine, but I still see all the role names, group names, and other
database names for the entire cluster. This is despite the fact the
target database has no pgAgent schema.

If I add a line to "DB restriction" with the word "production" I get:
   ERROR: column "production" does not exist
  LINE 7: WHERE datname IN (prodiction)

--
Bryce Nesbitt
The Berkeley Electronic Press
bepress: 10 years of accelerating and enhancing the flow of scholarly ideas

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2010-05-12 21:16:43 Re: Restricting login to a single database only (no visible table spaces, groups or roles)
Previous Message Guillaume Lelarge 2010-05-12 12:15:11 Re: Demand aide