details: https://code.openbravo.com/erp/devel/pi/rev/270c8e805fb3
changeset: 34164:270c8e805fb3
user: Carlos Aristu <carlos.aristu <at> openbravo.com>
date: Mon Jun 04 12:30:03 2018 +0200
summary: fixes bug 38689: Avoid setting as automatic a role that inherits
permissions
diffstat:
src-db/database/model/triggers/AD_ROLE_CHECK_TRG.xml | 6 ++++++
src-db/database/sourcedata/AD_MESSAGE.xml | 12 ++++++++++++
2 files changed, 18 insertions(+), 0 deletions(-)
diffs (38 lines):
diff -r e7f187bd7238 -r 270c8e805fb3
src-db/database/model/triggers/AD_ROLE_CHECK_TRG.xml
--- a/src-db/database/model/triggers/AD_ROLE_CHECK_TRG.xml Mon Jun 04
08:39:10 2018 +0200
+++ b/src-db/database/model/triggers/AD_ROLE_CHECK_TRG.xml Mon Jun 04
12:30:03 2018 +0200
@@ -46,6 +46,12 @@
RAISE_APPLICATION_ERROR(-20000, '@CannotChangeAccessLevel@');
END IF;
END IF;
+ IF (:OLD.ISMANUAL = 'Y' AND :NEW.ISMANUAL='N') THEN
+ SELECT COUNT(*) INTO v_count FROM dual WHERE EXISTS (SELECT 1 FROM
AD_ROLE_INHERITANCE WHERE AD_ROLE_ID = :NEW.AD_ROLE_ID);
+ IF (v_count <> 0) THEN
+ RAISE_APPLICATION_ERROR(-20000, '@CannotSetAsNotManual@');
+ END IF;
+ END IF;
END IF;
END AD_ROLE_CHECK_TRG
diff -r e7f187bd7238 -r 270c8e805fb3 src-db/database/sourcedata/AD_MESSAGE.xml
--- a/src-db/database/sourcedata/AD_MESSAGE.xml Mon Jun 04 08:39:10 2018 +0200
+++ b/src-db/database/sourcedata/AD_MESSAGE.xml Mon Jun 04 12:30:03 2018 +0200
@@ -17161,6 +17161,18 @@
<!--1C911FE5AD004BF29CA03F343A9E9B09-->
<ISINCLUDEINI18N><![CDATA[Y]]></ISINCLUDEINI18N>
<!--1C911FE5AD004BF29CA03F343A9E9B09--></AD_MESSAGE>
+<!--1CB513A6A3DF4D2D84E1CAF42A8F6EC2--><AD_MESSAGE>
+<!--1CB513A6A3DF4D2D84E1CAF42A8F6EC2-->
<AD_MESSAGE_ID><![CDATA[1CB513A6A3DF4D2D84E1CAF42A8F6EC2]]></AD_MESSAGE_ID>
+<!--1CB513A6A3DF4D2D84E1CAF42A8F6EC2-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--1CB513A6A3DF4D2D84E1CAF42A8F6EC2--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--1CB513A6A3DF4D2D84E1CAF42A8F6EC2--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--1CB513A6A3DF4D2D84E1CAF42A8F6EC2-->
<VALUE><![CDATA[CannotSetAsNotManual]]></VALUE>
+<!--1CB513A6A3DF4D2D84E1CAF42A8F6EC2--> <MSGTEXT><![CDATA[Is not possible to
uncheck the Manual flag for a role that is inheriting permissions]]></MSGTEXT>
+<!--1CB513A6A3DF4D2D84E1CAF42A8F6EC2--> <MSGTYPE><![CDATA[E]]></MSGTYPE>
+<!--1CB513A6A3DF4D2D84E1CAF42A8F6EC2-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--1CB513A6A3DF4D2D84E1CAF42A8F6EC2-->
<ISINCLUDEINI18N><![CDATA[N]]></ISINCLUDEINI18N>
+<!--1CB513A6A3DF4D2D84E1CAF42A8F6EC2--></AD_MESSAGE>
+
<!--1CF066F6A68F419CA5241635305B9B77--><AD_MESSAGE>
<!--1CF066F6A68F419CA5241635305B9B77-->
<AD_MESSAGE_ID><![CDATA[1CF066F6A68F419CA5241635305B9B77]]></AD_MESSAGE_ID>
<!--1CF066F6A68F419CA5241635305B9B77-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
