Adding a user for local umbraco Dev

On Server...

CREATE LOGIN [<login-name>] WITH PASSWORD='<yourPassword>'
CREATE USER [<user-name>] FOR LOGIN [<login-name>]

On DB...

CREATE USER [<user-name>] FOR LOGIN [<login-name>]
ALTER ROLE [db_owner] ADD MEMBER [<user-name>]