Thread: Privilege info is missing
Hi, I'm using PgAdmin3 v1.6 on Windows XP SP2 against Postgresql 8.1. This problem occurs in 1.4 also. I have 2 users in the database "postgres" and "test" with password set on both. The privilege tab in Table properties doesn't offer me the choice to select these users. It only shows "public" as available user in dropdown list. Can you please help? Stephen _________________________________________________________________ All-in-one security and maintenance for your PC.� Get a free 90-day trial! http://clk.atdmt.com/MSN/go/msnnkwlo0050000002msn/direct/01/?href=http://clk.atdmt.com/MSN/go/msnnkwlo0050000001msn/direct/01/?href=http://www.windowsonecare.com/?sc_cid=msn_hotmail
Check out "File" -> "Options..." "Preferences" Tab Checkbox "Show users for priviledges" It was disabled as the UI seems to get unresponsive when a large number of users must be loaded (I understand from the help). - Joris >-----Original Message----- >From: pgadmin-support-owner@postgresql.org >[mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Stephen Lim >Sent: zondag 19 november 2006 18:21 >To: pgadmin-support@postgresql.org >Subject: [pgadmin-support] Privilege info is missing > > >Hi, > >I'm using PgAdmin3 v1.6 on Windows XP SP2 against Postgresql >8.1. This problem occurs in 1.4 also. > >I have 2 users in the database "postgres" and "test" with >password set on both. > >The privilege tab in Table properties doesn't offer me the >choice to select these users. It only shows "public" as >available user in dropdown list. > >Can you please help? > > >Stephen > >_________________________________________________________________ >All-in-one security and maintenance for your PC. Get a free >90-day trial! >http://clk.atdmt.com/MSN/go/msnnkwlo0050000002msn/direct/01/?hr ef=http://clk.atdmt.com/MSN/go/msnnkwlo0050000001msn/direct/01/?href=http://www.windowsonecare.com/?sc_cid=msn_hotmail > > >---------------------------(end of >broadcast)--------------------------- >TIP 6: explain analyze is your friend >
Cool. Thanks! Stephen >From: "Joris Dobbelsteen" <Joris@familiedobbelsteen.nl> >To: "Stephen Lim" <jleelim@hotmail.com> >CC: <pgadmin-support@postgresql.org> >Subject: Re: [pgadmin-support] Privilege info is missing >Date: Sun, 19 Nov 2006 18:24:59 +0100 > >Check out "File" -> "Options..." >"Preferences" Tab >Checkbox "Show users for priviledges" > >It was disabled as the UI seems to get unresponsive when a large number of >users must be loaded (I understand from the help). > >- Joris > > >-----Original Message----- > >From: pgadmin-support-owner@postgresql.org > >[mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Stephen Lim > >Sent: zondag 19 november 2006 18:21 > >To: pgadmin-support@postgresql.org > >Subject: [pgadmin-support] Privilege info is missing > > > > > >Hi, > > > >I'm using PgAdmin3 v1.6 on Windows XP SP2 against Postgresql > >8.1. This problem occurs in 1.4 also. > > > >I have 2 users in the database "postgres" and "test" with > >password set on both. > > > >The privilege tab in Table properties doesn't offer me the > >choice to select these users. It only shows "public" as > >available user in dropdown list. > > > >Can you please help? > > > > > >Stephen > > > >_________________________________________________________________ > >All-in-one security and maintenance for your PC.� Get a free > >90-day trial! > >http://clk.atdmt.com/MSN/go/msnnkwlo0050000002msn/direct/01/?hr >ef=http://clk.atdmt.com/MSN/go/msnnkwlo0050000001msn/direct/01/?href=http://www.windowsonecare.com/?sc_cid=msn_hotmail > > > > > >---------------------------(end of > >broadcast)--------------------------- > >TIP 6: explain analyze is your friend > > > >---------------------------(end of broadcast)--------------------------- >TIP 2: Don't 'kill -9' the postmaster _________________________________________________________________ Talk now to your Hotmail contacts with Windows Live Messenger. http://clk.atdmt.com/MSN/go/msnnkwme0020000001msn/direct/01/?href=http://get.live.com/messenger/overview
> ------- Original Message ------- > From: "Joris Dobbelsteen" <Joris@familiedobbelsteen.nl> > To: "Stephen Lim" <jleelim@hotmail.com> > Sent: 19/11/06, 17:24:59 > Subject: Re: [pgadmin-support] Privilege info is missing > > Check out "File" -> "Options..." > "Preferences" Tab > Checkbox "Show users for priviledges" > > It was disabled as the UI seems to get unresponsive when a large number of users must be loaded (I understand from thehelp). It'll handle hundreds or thousands performance -wise - it's just a pita to select from a list that long, and assigning privsdirectly to a user isn't the best practice anyway. Regards, Dave