details: /erp/devel/pi/rev/be9aed3260c9
changeset: 8586:be9aed3260c9
user: Adrián Romero <adrianromero <at> openbravo.com>
date: Fri Oct 22 09:58:45 2010 +0200
summary: Fixes issue 014750: I can not access to the application when there
are many organizations.
It has been removed the wrong calculation in the security sentence
diffstat:
src/org/openbravo/base/secureApp/Seguridad_data.xsql | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 594ab4625cfa -r be9aed3260c9
src/org/openbravo/base/secureApp/Seguridad_data.xsql
--- a/src/org/openbravo/base/secureApp/Seguridad_data.xsql Thu Oct 21
17:50:13 2010 +0200
+++ b/src/org/openbravo/base/secureApp/Seguridad_data.xsql Fri Oct 22
09:58:45 2010 +0200
@@ -18,7 +18,7 @@
<SqlMethod name="select" type="preparedStatement" return="multiple">
<SqlMethodComment></SqlMethodComment>
<Sql><![CDATA[
- SELECT r.UserLevel,''''||replace(replace(r.ClientList,'
',''),',',''',''')||'''' as ClientList,''''||replace(replace(r.OrgList,'
',''),',',''',''')||'''' as OrgList,r.C_Currency_ID,r.AmtApproval,
+ SELECT r.UserLevel,'' as ClientList,'' as
OrgList,r.C_Currency_ID,r.AmtApproval,
r.AD_Client_ID, c.NAME, u.C_BPARTNER_ID, c.VALUE, c.SMTPHOST
FROM AD_ROLE r, AD_CLIENT c, AD_USER u,
AD_USER_ROLES ur
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
