Get Roles for a User

Use this API to retrieve all Roles assigned to a user.

Name

CDR_PUB_SECURITY_PKG.GetRolesForUser

Signature

FUNCTION GETROLESFORUSER( 
  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_USERID  IN    VARCHAR2 
) RETURN CLOB; 

Return

Type CLOB

Description CLOB for all roles for given user.

Parameters

This API has standard parameters. See Standard Parameters) for details.