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@xxxxxxxxxxx
