[pgadmin-support] Demand aide

2010-05-12 Thread Abdallah MEHDOINI
Bonjour je suis débutant dans l'utilisation de pgadmin et j'ai une base de donné deaja dévelloper sur MSSQLServer2005 et je suis interessaide faire migrer la base vers pgadmin (les tables ;les clé;etc) j'ai deux soucis pour ca comment faire la migration aussi sur sql server je peut faire de

Re: [pgadmin-support] Demand aide

2010-05-12 Thread Guillaume Lelarge
Le 12/05/2010 13:43, Abdallah MEHDOINI a écrit : > [...] > I am initial in the use of pgadmin > and I have a base of given deaja to develop on MSSQLServer2005 and I am > interessaide to make migrate the base towards pgadmin (the tables; the > key; etc) > I have two concern for that how to also m

[pgadmin-support] Restricting login to a single database only (no visible table spaces, groups or roles)

2010-05-12 Thread Bryce Nesbitt
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

Re: [pgadmin-support] Restricting login to a single database only (no visible table spaces, groups or roles)

2010-05-12 Thread Guillaume Lelarge
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 se

Re: [pgadmin-support] Restricting login to a single database only (no visible table spaces, groups or roles)

2010-05-12 Thread Bryce Nesbitt
On Wed, May 12, 2010 at 2:16 PM, Guillaume Lelarge wrote: > > You need to put ["DB restriction"] in quotes, as in 'production'. Or if you > want more than one restricted db: 'db1','db2' That works fine now. But the rest of the question remains: the inaccessible databases, users and groups still s

Re: [pgadmin-support] Restricting login to a single database only (no visible table spaces, groups or roles)

2010-05-12 Thread Guillaume Lelarge
Le 12/05/2010 23:58, Bryce Nesbitt a écrit : > On Wed, May 12, 2010 at 2:16 PM, Guillaume Lelarge > wrote: >> >> You need to put ["DB restriction"] in quotes, as in 'production'. Or if you >> want more than one restricted db: 'db1','db2' > > > That works fine now. > But the rest of the question r

Re: [pgadmin-support] Restricting login to a single database only (no visible table spaces, groups or roles)

2010-05-12 Thread Bryce Nesbitt
On Wed, May 12, 2010 at 4:00 PM, Guillaume Lelarge wrote: > If you use the "DB restriction" field, you should see only the > restricted databases. Users and groups will still be available. That's what I see. As a feature request then: have a way to suppress all but the active database. No Tables