SQL Statements

useful snippets

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:

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