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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
