Thread: "Search objects" fails in pgAdmin 1.16.0 Beta 4 on ubuntu linux
Hello, I built pgAdmin 1.16.0 Beta 4 from source on ubuntu 12.04. I am able to connect to my remote databases and work on them.I was eager to use the "Search objects" functionality, but if I use them on the remote databases, it gives me the followingerror: ERROR: permission denied for relation pg_user_mapping If I search on a local database where I have more privileges, this works. But I would think anyone that can create objectsin the db should be able to search them. Please let me know how to get through this. Thanks CG
On Tuesday, August 28, 2012 10:40:43 AM UTC-4, Chandrakant G wrote: > Hello, > > I built pgAdmin 1.16.0 Beta 4 from source on ubuntu 12.04. I am able to connect to my remote databases and work on them.I was eager to use the "Search objects" functionality, but if I use them on the remote databases, it gives me the followingerror: > > > > ERROR: permission denied for relation pg_user_mapping > > > > If I search on a local database where I have more privileges, this works. But I would think anyone that can create objectsin the db should be able to search them. > > > > Please let me know how to get through this. > > > > Thanks > > CG Has anybody been able to reproduce this bug? Just curious. Can anybody point me to a reason why pg_user_mapping is not grantedselect rights for public even though other tables are? Thanks CG
On Thu, 2012-08-30 at 07:34 -0700, Chandrakant G wrote: > On Tuesday, August 28, 2012 10:40:43 AM UTC-4, Chandrakant G wrote: > > Hello, > > > > I built pgAdmin 1.16.0 Beta 4 from source on ubuntu 12.04. I am able to connect to my remote databases and work on them.I was eager to use the "Search objects" functionality, but if I use them on the remote databases, it gives me the followingerror: > > > > > > > > ERROR: permission denied for relation pg_user_mapping > > > > > > > > If I search on a local database where I have more privileges, this works. But I would think anyone that can create objectsin the db should be able to search them. > > > > > > > > Please let me know how to get through this. > > > > > > > > Thanks > > > > CG > > Has anybody been able to reproduce this bug? Just curious. Can anybody point me to a reason why pg_user_mapping is notgranted select rights for public even though other tables are? > Sorry for the late answer. Only superuser can read into pg_user_mapping. This bug is now fixed (a search done with a super user will include the SQL/MED objects, while a search launched by a regular user won't include them). Thanks for the report. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
> > > Sorry for the late answer. Only superuser can read into pg_user_mapping. > > This bug is now fixed (a search done with a super user will include the > > SQL/MED objects, while a search launched by a regular user won't include > > them). > > > > Thanks for the report. > You are welcome. Thanks for the fix. Btw, how do I download the fix? Has it been rolled into the 1.16 beta 4 distributionavailable at http://www.postgresql.org/ftp/pgadmin3/release/v1.16.0-beta4/src/ ? Thanks CG
On Fri, 2012-08-31 at 15:13 -0700, Chandrakant G wrote: > > > > > > Sorry for the late answer. Only superuser can read into pg_user_mapping. > > > > This bug is now fixed (a search done with a super user will include the > > > > SQL/MED objects, while a search launched by a regular user won't include > > > > them). > > > > > > > > Thanks for the report. > > > > You are welcome. Thanks for the fix. Btw, how do I download the fix? The only way now is to grab the source code, and compile it. You can also wait that the new beta/RC/final gets out. > Has it been rolled into the 1.16 beta 4 distribution available at http://www.postgresql.org/ftp/pgadmin3/release/v1.16.0-beta4/src/? Absolutely not. Beta 4 is already released, it won't be changed. If you don't want to compile it, you'll need to wait for the next release (RC2 or the GA release). -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
Just wanted to say thanks for this. I downloaded and compiled the 1.16 source and now the search functionality works great!