# SQL Statements

```
use <database_name>
go
EXEC sp_change_users_login 'Update_One', 'sde', 'sde'
go
```

`ALTER USER [LOGIN_NAME] WITH PASSWORD = 'PASSWORD'`

```
use <database_name>
go
ALTER USER sde WITH login = sde
go
```

**Add a new user to a database:** <br>

```sql
// This is the new way of creating DB users
create user [user-login] with password = 'Password Here'
ALTER ROLE [db_owner] ADD MEMBER [user-login]
```

<br>