0

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: enter image description here

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

2 Answers 2

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>]
-1

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.