Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0004099Openbravo ERPC. Securitypublic2008-06-20 12:492019-04-02 15:10
normalminorhave not tried
0004099: Delete client should not drop constraints
Currently the Delete Client process drops the database constraints.
The implications of that are:
1) Users cannot be logged in while the Delete Client is run (this is a no-no in a SaaS deployment)
2) In PostgreSQL the process requires superuser privileges
No tags attached.
related to defect 00176413.0MP4 closed marvintm Delete Client process does not work (this issue also groups other tickets related to the Delete Client process) 
blocks feature request 00022543.0MP0 closed jpabloae The installer requires database superuser permissions 
blocks feature request 0003392pi acknowledged rmorley Rewrite all procedures that drop/disble DB constraints 
Issue History
2008-06-20 12:49cromeroNew Issue
2008-06-20 12:49cromeroAssigned To => cromero
2008-06-20 12:49cromerosf_bug_id0 => 1998651
2008-06-21 00:34jpabloaeRelationship addedblocks 0002254
2008-07-01 16:47pjuvaraNote Added: 0008108
2008-07-01 16:47pjuvaraSummaryDelete client should not need SuperUser privileges in PostgreSQL => Delete client should not drop constraints
2008-07-01 16:47pjuvaraDescription Updated
2008-07-01 16:47pjuvaraProjectionnone => minor fix
2008-07-01 16:47pjuvaraStatusnew => acknowledged
2008-07-01 16:47pjuvaraTag Attached: ReleaseCandidate
2008-11-10 13:11cromeroAssigned Tocromero => pjuvara
2008-11-16 12:17pjuvaraRelationship addedblocks 0003392
2008-11-16 12:17pjuvaraTag Detached: ReleaseCandidate
2009-05-22 19:36pjuvaraAssigned Topjuvara => iciordia
2011-06-14 16:38dmitry_mezentsevRelationship addedrelated to 0017641
2019-04-02 15:10ngarciaIssue Monitored: ngarcia

2008-07-01 16:47   
Original description was:
>Now, the Delete Client process requires SuperUser privileges in PostgreSQL (to >disable/enable constraints).
>It would be nice that this should not be necessary for security reasons.