Fix xt.grant_role_ext() error causing empty rows.
authorBen Thompson <ben@xtuple.com>
Tue, 15 Apr 2014 17:58:03 +0000 (13:58 -0400)
committerBen Thompson <ben@xtuple.com>
Tue, 15 Apr 2014 17:58:03 +0000 (13:58 -0400)
enyo-client/database/source/xt/functions/grant_role_ext.sql

index ab49604..d73b17f 100644 (file)
@@ -18,7 +18,7 @@ create or replace function xt.grant_role_ext(role_name text, ext_name text) retu
     return false;
   } else {
     roleId = role[0].grp_id;
-    extId = ext[0].grp_id;
+    extId = ext[0].ext_id;
     count = plv8.execute(sqlCount, [roleId, extId])[0].count;
   }