pears.NetOwnerSettingsGetRightAllowed

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

CREATE PROCEDURE "pears"."NetOwnerSettingsGetRightAllowed"( IN "pWebUserID" CHAR(20) ) 
RESULT( "rightID" CHAR(255),"userClass" CHAR(255),"MaintainOnWeb" CHAR(1) ) 
BEGIN
  IF NOT "IQXNetHasPermission"("pWebUserID",'APIDESIGN') = 0 THEN
    SELECT "IQXNetRightID" AS "rightID","IQXNetUserClassID" AS "userClass","MaintainOnWeb" FROM "IQXNetRightAllowed"
  ELSE
    SELECT '99:~Permission denied','',''
  END IF
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetOwnerSettingsGetRightAllowed" IS 
{CREATE PROCEDURE pears."NetOwnerSettingsGetRightAllowed"( IN "pWebUserID" CHAR(20)) 
RESULT( "rightID" CHAR(255), "userClass" CHAR(255), "MaintainOnWeb" CHAR(1)) 
BEGIN
    IF NOT "IQXNetHasPermission"("pWebUserID",'APIDESIGN') = 0 THEN
        SELECT IQXNetRightID AS rightID, IQXNetUserClassID AS userClass, MaintainOnWeb FROM IQXNetRightAllowed
    ELSE
        SELECT '99:~Permission denied', '', '';
    END IF;
END
}
  • database/procedures/pears_netownersettingsgetrightallowed.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1