Returns one row for each member of each database role.
Database Principal ID of the role.
Database Principal ID of the member.
In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.