2011/11/17 Flávio Alves Granato <[email protected]>:
>
> Via pgadmin:
> CREATE ROLE teste LOGIN
>   ENCRYPTED PASSWORD 'md5280f5324cbe33b72ebeefbf2f879e216'
>   NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
>
> via jdbc:
> CREATE ROLE flavio LOGIN
>   ENCRYPTED PASSWORD 'md5bf5a1a18f98fd6debde92560c933d2d9'
>   NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
>
> que comportamento estranho.
>

O hash que o Postgres armazena corresponde a concatenação do login com
a senha, por isso da diferença. [1]

[1] http://www.postgresql.org/docs/current/static/catalog-pg-authid.html
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a