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

Hi,

Le 12/05/2010 22:44, Bryce Nesbitt a écrit :
> 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)
>

You need to put quotes, as in 'production'. Or if you want more than one
restricted db: 'db1','db2'

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com