Thread: "Search objects" fails in pgAdmin 1.16.0 Beta 4 on ubuntu linux

"Search objects" fails in pgAdmin 1.16.0 Beta 4 on ubuntu linux

From
Chandrakant G
Date:
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



Re: "Search objects" fails in pgAdmin 1.16.0 Beta 4 on ubuntu linux

From
Chandrakant G
Date:
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



Re: "Search objects" fails in pgAdmin 1.16.0 Beta 4 on ubuntu linux

From
Guillaume Lelarge
Date:
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




Re: "Search objects" fails in pgAdmin 1.16.0 Beta 4 on ubuntu linux

From
Chandrakant G
Date:
> 
> 
> 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



Re: "Search objects" fails in pgAdmin 1.16.0 Beta 4 on ubuntu linux

From
Guillaume Lelarge
Date:
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




Re: "Search objects" fails in pgAdmin 1.16.0 Beta 4 on ubuntu linux

From
Chandrakant G
Date:
Just wanted to say thanks for this. I downloaded and compiled the 1.16 source and now the search functionality works
great!