pears.NetOwnerSettingsGetRight [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== pears.NetOwnerSettingsGetRight ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
create procedure "pears"."NetOwnerSettingsGetRight"( in "pWebUserID" char(20) ) 
result( "rightID" char(255),"description" long varchar ) 
// IQXWeb
begin
  if not "IQXNetHasPermission"("pWebUserID",'APIDESIGN') = 0 then
    select "IQXNetRightID" as "rightID","Description" as "description" from "IQXNetRight"
      order by "SortOrder" asc
  else
    select '99:~Permission denied',''
  end if
end
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetOwnerSettingsGetRight" IS 
{create PROCEDURE pears."NetOwnerSettingsGetRight"( in "pWebUserID" char(20)) 
result( "rightID" char(255),"description" long varchar ) 
// IQXWeb
begin
    if not "IQXNetHasPermission"("pWebUserID",'APIDESIGN') = 0 then
        SELECT IQXNetRightID as rightID, Description as description from IQXNetRight
        order by SortOrder
    else
        select '99:~Permission denied', '';
    end if;
end
}
</code>