Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012959Openbravo ERP01. General setuppublic2010-04-13 20:292010-04-19 21:13
Reporternetworkb 
Assigned Toadrianromero 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS Version
Product Version2.50MP13 
Target VersionFixed in Version2.50MP15 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012959: You can give the Systemadministrator orgaccess to an organization other than '*'
DescriptionYou can give the Systemadministrator orgaccess to an organization other than '*'. After that, if your role by default for Openbravo user is System administrator you can't log in in the application again with Openbravo User.
Steps To ReproduceLog in as Openbravo Admin.
Go to General Setup || Security || Role Access >> Select System admin role and go to tab "Org Access"
Create a new record for any organization (not *)
log out
log in as Openbravo

Notice that is not possible to log in.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-04-13 20:29networkbNew Issue
2010-04-13 20:29networkbAssigned To => adrianromero
2010-04-14 12:44hgbotCheckin
2010-04-14 12:44hgbotNote Added: 0026173
2010-04-14 12:44hgbotStatusnew => resolved
2010-04-14 12:44hgbotResolutionopen => fixed
2010-04-14 12:44hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f6069809175eb0435f931d12ec46cd7699358af9 [^]
2010-04-14 13:14adrianromeroNote Added: 0026178
2010-04-14 16:31hgbotCheckin
2010-04-14 16:31hgbotNote Added: 0026196
2010-04-14 16:31hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/f6069809175eb0435f931d12ec46cd7699358af9 [^] => http://code.openbravo.com/erp/devel/pi/rev/9c230b478c15aad7893d09e4e80c3f98f54bce74 [^]
2010-04-15 17:26psarobeNote Added: 0026285
2010-04-15 17:26psarobeStatusresolved => closed
2010-04-15 17:26psarobeFixed in Version => 2.50MP15
2010-04-16 00:00anonymoussf_bug_id0 => 2987983
2010-04-19 21:13hudsonbotCheckin
2010-04-19 21:13hudsonbotNote Added: 0026473
2010-04-19 21:13hudsonbotCheckin
2010-04-19 21:13hudsonbotNote Added: 0026477

Notes
(0026173)
hgbot   
2010-04-14 12:44   
Repository: erp/devel/pi
Changeset: f6069809175eb0435f931d12ec46cd7699358af9
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Wed Apr 14 12:57:46 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f6069809175eb0435f931d12ec46cd7699358af9 [^]

Fixes issue 0012959: You can give the Systemadministrator orgaccess to an organization other than *

---
M src-db/database/sourcedata/AD_MESSAGE.xml
A src-db/database/model/triggers/AD_ROLE_CHECK_TRG.xml
A src-db/database/model/triggers/AD_ROLE_ORGACCESS_CHECK_TRG.xml
---
(0026178)
adrianromero   
2010-04-14 13:14   
* Testing of the issue:
To test the issue, as Openbravo Admin, create a new role with user level "System" or use the current "System administrator" role. Go to the tab "Org access" and try to create a new record with an organization different thant the super-organization "*". An error message will appear preventing this operation.

* Explanation of the changeset that fixes the issue:
The changeset that fix this issue consist in two triggers one that prevents to insert new registers in the AD_ROLE_ORGACCESS table for system roles with an organization different than "*" and other trigger in the AD_ROLE table that prevents to change the user level to "System" if the role as assigned organizations different than *. The changeset also includes the message shown in the trigger.

* Other areas affected by the changeset:
The only areas affected by this change set are when trying to insert or modify in the tables AD_ROLE and AD_ROLE_ORGACCESS. And affected windows has been tested.
(0026196)
hgbot   
2010-04-14 16:31   
Repository: erp/devel/pi
Changeset: 9c230b478c15aad7893d09e4e80c3f98f54bce74
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Wed Apr 14 16:43:54 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/9c230b478c15aad7893d09e4e80c3f98f54bce74 [^]

Fixes issue 0012959: You can give the Systemadministrator orgaccess to an organization other than *

---
M src-db/database/model/triggers/AD_ROLE_CHECK_TRG.xml
M src-db/database/model/triggers/AD_ROLE_ORGACCESS_CHECK_TRG.xml
---
(0026285)
psarobe   
2010-04-15 17:26   
Tested working fine
(0026473)
hudsonbot   
2010-04-19 21:13   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/f6069809175e [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/91d98bda46c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17088.obx [^]
(0026477)
hudsonbot   
2010-04-19 21:13   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/9c230b478c15 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/91d98bda46c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17088.obx [^]