use master
create login User1 with password = 'UserPas5'
grant alter on login::User1 to User1
use Geotema_Users
create user User1 from login User1
alter role UserRole add member User1
use fødselsrate_2017
create user User1 from login User1
alter role UserRole add member User1

use master
create login Admin1 with password = 'AdminPas5'
create server role ServerAdminRole
grant alter on server role::ServerAdminRole to ServerAdminRole with grant option
grant alter any login to ServerAdminRole with grant option
alter server role ServerAdminrole add member Admin1
use fødselsrate_2017
create user Admin1 from login Admin1
alter role AdminRole add member Admin1
use Geotema_Users
create user Admin1 from login Admin1
alter role AdminRole add member Admin1

use master
create login Super1 with password = 'SuperPas5'
grant alter on login::Super1 to Super1
use fødselsrate_2017
create user Super1 from login Super1
alter role SuperRole add member Super1
use Geotema_Users
create user Super1 from login Super1
alter role UserRole add member Super1