How do I update azure SQL baseline to remove certain db owners?

Question

I need to update the baseline to reflect only the approved list of owners and remove others. Can anyone tell me how do I do that? Here is what I see:

How do I remove the owners from baseline marked in red?

Answer 1

You can remove members from a role using the sp_droprolemember stored procedure. Similarly, the stored procedure sp_addrolemember can add additional users to the role.

Here is a statement to remove members from the db_owner role.

EXEC sp_droprolemember [db_owner],[<User Name here>]

Answer 2

Another easier way to do this is by clicking on 'Approve as a baseline' after adding or removing the database permissions of the users.