# MSSQL cheatsheet

```
USE DatabaseName
CREATE USER username FOR LOGIN username
GO
EXEC sp_addrolemember db_owner, username
GO
```

For read-only access you would want to use `db_datareader` role instead of `db_owner`.
For read and write (but not changing schema, etc.) add it to both `db_datareader` and `db_datawriter`

Or, if you need more fine-grain control you may specifically
`GRANT`/`REVOKE`/`DENY` `select`/`insert`/`update`/`delete` permissions
on tables or views and/or exec permissions on functions and stored procs:

```
USE DatabaseName
GRANT INSERT ON table_name TO username
```