DOES_USER_HAVE_ROLE

Arguments:

Returns:

Source

Legend: comment string keyword reserved word operator

     1: function
     2: does_user_have_role
     3: (
     4: 	user_id_in in number,
     5: 	role_in in varchar2
     6: )
     7: return number
     8: is
     9: 	org_admin	number;
    10: begin
    11: 	select	1
    12: 	into	org_admin
    13: 	from
    14: 		rhnUserGroupType	ugt,
    15: 		rhnUserGroup		ug,
    16: 		rhnUserGroupMembers	ugm
    17: 	where	1=1
    18: 		and ugm.user_id = user_id_in
    19: 		and ugm.user_group_id = ug.id
    20: 		and ugt.label = role_in
    21: 		and ugt.id = ug.group_type;
    22: 	return org_admin;
    23: exception
    24: 	when no_data_found then
    25: 		return 0;
    26: end;