SSOQ
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
IDM_STAGING.EMSA_IDM_PROF_SECURITY_LEVEL
Parameters
Name
Type
Mode
Definition
PACKAGE BODY EMSA_IDM_PROF_SECURITY_LEVEL AS ------------------------------------------------------------------------------------------------------------------------------------ -- Function to retrieve the maximum security level. -- prof_object_id: It holds the account username of the user. ------------------------------------------------------------------------------------------------------------------------------------ FUNCTION maxrelatedsecurity ( prof_object_id IN VARCHAR2 ) RETURN NUMBER IS security_level NUMBER := 1; BEGIN SELECT NVL(MAX(r.security_level),1) sec_level INTO security_level FROM profile pro LEFT OUTER JOIN profile_role pr ON ( pro.object_id = pr.profile_object_id ) LEFT OUTER JOIN role r ON ( pr.role_object_id = r.object_id ) WHERE pr.active = 1 AND r.active = 1 AND pro.object_id = prof_object_id GROUP BY pro.object_id; RETURN security_level; END maxrelatedsecurity; -- ***************************************************************************************************************************** -- FUNCTION maxrelatedsecurity ends -- ***************************************************************************************************************************** END EMSA_IDM_PROF_SECURITY_LEVEL;