Revoke a User Group From an Object

Use this API to revoke a User Group from an object.

To remove access to an object through an inheritedUser Group, you must revoke the User Group assignment.

Use Unassign User Group from Object (UNASSIGNUSRGRPFROMOBJ) for User Groups assigned explicitly.)

Name

CDR_PUB_SECURITY_PKG.RevokeUsrGrpFromObJ

Signature

PROCEDURE REVOKEUSRGRPFROMOBJ( 
  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, 
  X_RETURN_STATUS  OUT    VARCHAR2, 
  X_MSG_COUNT  OUT    NUMBER, 
  X_MSG_DATA  OUT    VARCHAR2, 
  PI_BASEOBJECTTYPE  IN OUT    CDR_BASE_OBJ_TYPE, 
  PI_CDROBJUGOBJTYPE  IN    CDR_OBJ_UG_OBJ_TYPE, 
  PO_HASVIEWPERMAFTERREVOKE  OUT    VARCHAR2 
); 

Parameters

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

  • PI_BASEOBJECTTYPE (Mandatory) This is a parameter of table type CDR_BASE_OBJ_TYPE. Enter values to identify the object from which the User Group is to be revoked.

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

  • PI_CDROBJUGOBJTYPE (Mandatory) This is a parameter of table type CDR_OBJ_UG_OBJ_TYPE that contains information about the object and the User Group.
  • PO_HASVIEWPERMAFTERREVOKE (Mandatory) Enter appropriate values for this parameter to specify whether view permissions exist after the revoking of the User Group from the object.