Re: [GENERAL] Changing Passwords as Encrypted not Clear-Text

2011-12-19 Thread Adrian Klaver
On Monday, December 19, 2011 11:46:05 am MURAT KOÇ wrote: > Hi Adrian, > > Both of advices that are using md5 algorithm and setting log_statement for > session specific worked well. > > Thanks for suggestions and solution advices. Glad it worked. A thought came to mind just now. If you decide to

Re: [GENERAL] Changing Passwords as Encrypted not Clear-Text

2011-12-19 Thread MURAT KOÇ
Hi Adrian, Both of advices that are using md5 algorithm and setting log_statement for session specific worked well. Thanks for suggestions and solution advices. Best Regards, Murat KOC 2011/12/19 Adrian Klaver > On Monday, December 19, 2011 7:26:33 am MURAT KOÇ wrote: > > Hi Adrian, > > > > I

Re: [GENERAL] Changing Passwords as Encrypted not Clear-Text

2011-12-19 Thread Adrian Klaver
On Monday, December 19, 2011 7:26:33 am MURAT KOÇ wrote: > Hi Adrian, > > I wrote a desktop application on Windows by using "Npgsql.dll". So, I send > SQL statement to database from this application code. I can't use psql > command line (I know "\password" command changes password encrypted text).

Re: [GENERAL] Changing Passwords as Encrypted not Clear-Text

2011-12-19 Thread Magnus Hagander
On Mon, Dec 19, 2011 at 15:31, Guillaume Lelarge wrote: > On Mon, 2011-12-19 at 15:01 +0200, MURAT KOÇ wrote: >> Is it possible to see changing passwords as encrypted? > > Nope. > >>  How should I change password or what is the correct sql statement to change >> user password? >> > > There's only

Re: [GENERAL] Changing Passwords as Encrypted not Clear-Text

2011-12-19 Thread Alban Hertroys
> Of course, we could create login credentials, login configuration options > for every DBA colleagues. But, as I said previous that big problem is > "PostgreSQL logs include changing passwords on clear-text not encrypted" No, the big problem is that you don't consider your fellow DBA's reliable.

Re: [GENERAL] Changing Passwords as Encrypted not Clear-Text

2011-12-19 Thread MURAT KOÇ
Hi, My answers are written under your comments. Best Regards Murat KOC 2011/12/19 Alban Hertroys > On 19 December 2011 16:26, MURAT KOÇ wrote: > > Hi Adrian, > > > > I wrote a desktop application on Windows by using "Npgsql.dll". So, I > send > > SQL statement to database from this applicatio

Re: [GENERAL] Changing Passwords as Encrypted not Clear-Text

2011-12-19 Thread Adrian Klaver
On Monday, December 19, 2011 7:26:33 am MURAT KOÇ wrote: > Hi Adrian, > > I wrote a desktop application on Windows by using "Npgsql.dll". So, I send > SQL statement to database from this application code. I can't use psql > command line (I know "\password" command changes password encrypted text).

Re: [GENERAL] Changing Passwords as Encrypted not Clear-Text

2011-12-19 Thread Guillaume Lelarge
On Mon, 2011-12-19 at 17:19 +0200, MURAT KOÇ wrote: > Thanks for reply. But it's not suitable to trust the people who have > access to the logs. > > Think, I changed my DB password and other DBA colleague who has access > to the PostgreSQL logs has seen my DB password. He started to use my > DB p

Re: [GENERAL] Changing Passwords as Encrypted not Clear-Text

2011-12-19 Thread Alban Hertroys
On 19 December 2011 16:26, MURAT KOÇ wrote: > Hi Adrian, > > I wrote a desktop application on Windows by using "Npgsql.dll". So, I send > SQL statement to database from this application code. I can't use psql > command line (I know "\password" command changes password encrypted text). > > Because

Re: [GENERAL] Changing Passwords as Encrypted not Clear-Text

2011-12-19 Thread MURAT KOÇ
Hi Adrian, I wrote a desktop application on Windows by using "Npgsql.dll". So, I send SQL statement to database from this application code. I can't use psql command line (I know "\password" command changes password encrypted text). Because of this, I have to use "ALTER USER" statement from applic

Re: [GENERAL] Changing Passwords as Encrypted not Clear-Text

2011-12-19 Thread MURAT KOÇ
Thanks for reply. But it's not suitable to trust the people who have access to the logs. Think, I changed my DB password and other DBA colleague who has access to the PostgreSQL logs has seen my DB password. He started to use my DB password instead of his password. He executed all DDL and DML sta

Re: [GENERAL] Changing Passwords as Encrypted not Clear-Text

2011-12-19 Thread Adrian Klaver
On Monday, December 19, 2011 5:01:28 am MURAT KOÇ wrote: > Hi List, > > When I try to change my db password like below SQL statement from psql or > pgAdmin tool, it outputs to server logs as like this: > > *postgres=# alter user mkoc password 'dummy'; > ALTER ROLE > postgres=# alter user mkoc wi

Re: [GENERAL] Changing Passwords as Encrypted not Clear-Text

2011-12-19 Thread Guillaume Lelarge
On Mon, 2011-12-19 at 15:01 +0200, MURAT KOÇ wrote: > Hi List, > > When I try to change my db password like below SQL statement from psql or > pgAdmin tool, it outputs to server logs as like this: > > *postgres=# alter user mkoc password 'dummy'; > ALTER ROLE > postgres=# alter user mkoc with pa

[GENERAL] Changing Passwords as Encrypted not Clear-Text

2011-12-19 Thread MURAT KOÇ
Hi List, When I try to change my db password like below SQL statement from psql or pgAdmin tool, it outputs to server logs as like this: *postgres=# alter user mkoc password 'dummy'; ALTER ROLE postgres=# alter user mkoc with password 'dummy'; ALTER ROLE * ### Server Logs ### 2011-12-19 14:35:3