USP_GETSERVICEROLEUSERS

CREATE procedure dbo.[USP_GETSERVICEROLEUSERS]
with execute as owner 
as
begin

select
  p.[name] as [SERVICEROLEUSER]
from sys.[database_role_members] drm
inner join sys.[database_principals] p on drm.[member_principal_id] = p.[principal_id]
inner join sys.[database_principals] rp on drm.[role_principal_id] = rp.[principal_id]
where rp.[name] = 'BBAPPFXSERVICEROLE'

end