Skip site navigation (1)
Skip section navigation (2)
Hi,
I have a database in postgres and i've given trusted permissions to all making required changes
in pg_hba.conf.
Now, I'm trying to connect to the database using ECPG. Unfortunately after
EXEC SQL CONNECT dbxyz
gives me error -402 that means i don't have permissions to the database.
I'm running this ECPG code under root permissions.
Don't know what needs to be done to make it work.
Is there some kind of a script file that needs to be run
so that everything is well in place.
Regards,
~Jas
Peripheral Links
Header And Logo
|
Site Navigation
Permissions to connect to postgres database
- From: "Jasbinder Bali" <jsbali(at)gmail(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Permissions to connect to postgres database
- Date: Thu, 27 Jul 2006 11:32:15 -0400
Hi,
I have a database in postgres and i've given trusted permissions to all making required changes
in pg_hba.conf.
Now, I'm trying to connect to the database using ECPG. Unfortunately after
EXEC SQL CONNECT dbxyz
gives me error -402 that means i don't have permissions to the database.
I'm running this ECPG code under root permissions.
Don't know what needs to be done to make it work.
Is there some kind of a script file that needs to be run
so that everything is well in place.
Regards,
~Jas
- Follow-Ups:
- Re: Permissions to connect to postgres database
- From: Richard Huxton
- Re: Permissions to connect to postgres database
- Prev by Date: UTF-8, upper() and Chinese characters yielding blank result
- Next by Date: Update entire column with new date values
- Previous by thread: UTF-8, upper() and Chinese characters yielding blank result
- Next by thread: Re: Permissions to connect to postgres database
- Indexes: