Hi list,
In Oracle, it could be created a user profile called "PROFILE" and this
profile could have below specifications:
PASSWORD_LIFE_TIME (that describes when password will expire)
FAILED_LOGIN_ATTEMPTS (specifies number of failed login attempts before
locking user account)
PASSWORD_LOCK_T
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,
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
>
uot;ALTER USER" statement from application
code. Or what could you give another advice?
Best Regards
Murat KOC
2011/12/19 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 state
d DML statements with my DB account. In fact, I did
nothing but because of this gap I did all things.
Is it a trustable situation ? How will we identify who is guilty he or me?
Best Regards
Murat KOC
2011/12/19 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 password 'dummy';
ALTER ROLE
*
### Server Logs ###
2011-12-19 14:35:3
tatement = 'mod').
Regards,
Murat KOC
2011/11/30 Albe Laurenz
> MURAT KOÇ wrote:
> > Version is PostgreSQL 9.0.4 on x86_64-unknown-linux-gnu, compiled by GCC
> gcc (GCC) 4.1.2 20080704 (Red
> > Hat 4.1.2-51), 64-bit.
> >
> > We set logging parameters as
Hi list,
Version is PostgreSQL 9.0.4 on x86_64-unknown-linux-gnu, compiled by GCC
gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-51), 64-bit.
We set logging parameters as below for DDL & DML Logging:
logging_collector = on
log_statement = mod
log_line_prefix = '%t--%d--%u--%h--%a--%i--%e'
Server log f
