From: | Julien Rouhaud <julien(dot)rouhaud(at)dalibo(dot)com> |
---|---|
To: | Joseph Brenner <doomvox(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: No select privileges when not connecting from login postgres |
Date: | 2016-12-03 14:56:48 |
Message-ID: | 20161203145648.GA29303@nol.local |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Nov 30, 2016 at 08:48:41PM -0800, Joseph Brenner wrote:
> I'm trying to get a new build of 9.6.1 working on a machine
> running Debian stable (jessie) and I'm seeing some odd
> behavior where things work correctly if I run psql when
> logged in as postgres, but if I run it as user 'doom' (my
> usual login), I don't seem to have any select privileges.
> Even this fails silenlty:
>
> select 'world' as hello;
>
> But if run logged in as postgres, all is well:
>
> sudo su - postgres
> /usr/local/pgsql/bin/psql --dbname=doom --username=doom
> doom=# select 'world' as hello;
> select 'world' as hello;
> hello
> -------
> world
> (1 row)
> [...]
> I'm running out of ideas for things to check. Any suggestions?
>
Any unusual errors in the logs? Or maybe a "\o /somefile" in your
~doom/.psqlrc?
--
Julien Rouhaud
http://dalibo.com - http://dalibo.org
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2016-12-03 15:10:45 | Re: No select privileges when not connecting from login postgres |
Previous Message | Melvin Davidson | 2016-12-03 14:55:45 | Re: Any work being done on materialized view? |