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?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this communityYou 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>]
Another easier way to do this is by clicking on 'Approve as a baseline' after adding or removing the database permissions of the users.