Project

General

Profile

Actions
Copy link

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 12 years ago. Updated over 12 years ago.

Status:
Rejected
Priority:
1 (highest)
Assignee:
Nicolas PERRON
Category:
System techniques
Target version:
2.4.0~beta4
Pull Request:
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
Copy link
 #1

Updated by Nicolas PERRON over 12 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
Copy link

Also available in: Atom PDF