Project

General

Profile

Actions

Bug #2833

closed

On Rudder 2.4.0~beta3, in distributePolicy/1.0/passwordCheck.st PostgreSQL password for the user rudder is changed for all databases

Added by Nicolas PERRON over 11 years ago. Updated over 11 years ago.

Status:
Rejected
Priority:
1
Assignee:
Nicolas PERRON
Category:
System techniques
Target version:
Severity:
UX impact:
User visibility:
Effort required:
Priority:
Name check:
Fix check:
Regression:

Description

The promise passwordCheck.st command line for changing password is too rough with PostgreSQL. It changes all databases password for the user rudder although only rudder database is concerned.

Actions #1

Updated by Nicolas PERRON over 11 years ago

  • Status changed from New to Rejected

Oh, this is stupid. An user can't have a different password for each database. I was confused by reading too quickly these phrases (fom http://www.postgresql.org/docs/8.1/static/auth-methods.html):

PostgreSQL database passwords are separate from operating system user passwords. The password for each database user is stored in the pg_authid system catalog.[...]

An user has an unique password, that's all. If he is owner of several databases, the same password would be used for all of them.

Then, I reject this bug.

Actions

Also available in: Atom PDF