@SecurityCheck

Implements row filtering so that only granted data is visible or processed.

Category: security

Security checks are made on specified parameters to a PL/SQL method or as a filter on views to show only accessible rows.

PL/SQL Method Example

As shown in the following example for PL/SQL method the annotation has a parameter that indicated what check that is performed passing the PL/SQL method parameter.

@SecurityCheck Company.UserAuthorized(company_)
FUNCTION Get_Adv_Inv_Dom_Balance (
   company_            IN VARCHAR2,
   identity_           IN VARCHAR2,
   party_type_         IN VARCHAR2 ) RETURN NUMBER
IS
   ...

PL/SQL View Example

As shown in the following example for PL/SQL view the annotation has a parameter that indicated what check that is performed passing the column of it's select statement.

@SecurityCheck Company.UserAuthorized(it.company)
VIEW Invoice_Ledger_Item_Cu_Qry IS
SELECT it.company                           company,
       Party_Type_API.Decode(it.party_type) party_type,
       it.party_type                        party_type_db,
       it.invoice_id                        invoice_id,
       it.series_id                         series_id,
       it.invoice_no                        invoice_no,
       lit.ledger_item_version              ledger_item_version,
       ...

Available values

Company.UserAuthorized

Company.UserExist

Site.UserAuthorized

Employee.UserAuthorized

Employee.AttributeAccess

HR.CompanyAvailable

HR.EmployeeAvailable

HR.EmployeeAtDateAvailable

HR.EmployeeAtOrgAvailable

HR.EmployeeAtDateOrgAvailable

HR.AbsenceTypeAvailable

Component.ActiveCrud

Component.ActiveRead

LuComponent.ActiveCrud

LuComponent.ActiveRead

This page is generated from IFS Developer Studio at 2021-08-13 08:40.