Hi, I want to modify the user permission at the DR database on log shipping with standby ead only mode. it does not let me modify because the database is read only mode . is there a way around it without disturbing / disabling the log shipping. thanks
You can't becuase db is standby mode which means you read but not write (modify)... Even you disable/stop the log shipping and change what ever you want, it will go back once the log shipping started because destination db is the same as source db... Only option would be if the same user exists in source db then change the permissions there and log restore will copy the permissions to destination server.