Initialize Access to a Security View

Use this API to initialize access to a Security View for a certain session, to a specific application user.

The API also checks whether the application user has relevant LSH functional security permission to access the Security View data. If the validation is successful, access permission is granted for a given session.

Name

CDR_PUB_SECURITY_PKG.InitializeAccessToSecView

Return

Boolean

• True: The user has the functional security permission.
• False: The user does not have the functional security permission.

Signature

FUNCTION INITIALIZEACCESSTOSECVIEW(
  P_API_VERSION  IN    NUMBER, 
  P_INIT_MSG_LIST  IN    VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, 
  P_COMMIT  IN    VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, 
  P_VALIDATION_LEVEL  IN    NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, 
  P_VIEW_NAME VARCHAR2)
  RETURN BOOLEAN;

Parameters

This API has standard parameters (see Standard Parameters) and the following parameter:

• P_VIEW_NAME (Mandatory) Enter the public Security View name you need access for:
  • CDR_PUB_UG_ROLES_V
  • CDR_PUB_USER_UG_ROLES_V
  • CDR_PUB_SUBTYPE_OPR_ROLES_V
  • CDR_PUB_OBJ_UG_V

  To access all security views in given session, enter CDR_ALL_PUB_SEC_V.

  The following attributes are required: COMPANY_ID, OBJ_ID, OBJ_VER, OBJECT_VERSION_NUMBER, NAMESPACE_OBJ_ID, NAMESPACE_OBJ_VER.