On 05/16/2014 08:41 AM, image wrote:
> Dear all,
>
> Thank you for your replies.Before taking into account your last proposals, I
> would like to tell you : I noticed that i don't get error message when i use
> the default user (postgres). But when i use my new user account (laurent), i
> get the error message.
Did you set up a password for laurent?
>
> With pgadmin3 i would like edit the authorization for the database (recalled
> web_service). But when i try to add permissions, i can't click on "ok"
> because it's neutralized (grayed").
At a guess you logged in as laurent not as the database superuser
postgres. This assumes laurent is not a superuser. This would explain
why you do not have rights to grant permissions.
>
> On the following screen shot (pgadmin), below, we notice the defalut value
> (TC) for the 'public' role. Here the role seems to be meaning the windows
> account and not the postgres role?
No it would be the Postgres role.
>
> SS_permissions.JPG
> <http://postgresql.1045698.n5.nabble.com/file/n5804240/SS_permissions.JPG>
>
> May be i have to do edit something into the pghba.conf in order to authorize
> connection for the new role laurent? For information, i'm working under
> 'laurent' windows session.
Can you show your pg_hba.conf file?
>
> Thank you to throw light for me.
>
> Regards.
>
>
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/Psycopg2-error-message-tp5804197p5804240.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com