Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0004099
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] C. Securityminorhave not tried2008-06-20 12:492019-04-02 15:10
ReportercromeroView Statuspublic 
Assigned Toiciordia 
PrioritynormalResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revision
Projectionminor fixETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0004099: Delete client should not drop constraints

DescriptionCurrently 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00176413.0MP4 closedmarvintm Delete Client process does not work (this issue also groups other tickets related to the Delete Client process) 
blocks feature request 00022543.0MP0 closedjpabloae The installer requires database superuser permissions 
blocks feature request 0003392pi acknowledgedrmorley Rewrite all procedures that drop/disble DB constraints 

-  Notes
(0008108)
pjuvara (reporter)
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.

- Issue History
Date Modified Username Field Change
2008-06-20 12:49 cromero New Issue
2008-06-20 12:49 cromero Assigned To => cromero
2008-06-20 12:49 cromero sf_bug_id 0 => 1998651
2008-06-21 00:34 jpabloae Relationship added blocks 0002254
2008-07-01 16:47 pjuvara Note Added: 0008108
2008-07-01 16:47 pjuvara Summary Delete client should not need SuperUser privileges in PostgreSQL => Delete client should not drop constraints
2008-07-01 16:47 pjuvara Description Updated
2008-07-01 16:47 pjuvara Projection none => minor fix
2008-07-01 16:47 pjuvara Status new => acknowledged
2008-07-01 16:47 pjuvara Tag Attached: ReleaseCandidate
2008-11-10 13:11 cromero Assigned To cromero => pjuvara
2008-11-16 12:17 pjuvara Relationship added blocks 0003392
2008-11-16 12:17 pjuvara Tag Detached: ReleaseCandidate
2009-05-22 19:36 pjuvara Assigned To pjuvara => iciordia
2011-06-14 16:38 dmitry_mezentsev Relationship added related to 0017641
2019-04-02 15:10 ngarcia Issue Monitored: ngarcia


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker