use master
if exists(select * from sys.databases where name='GeoTema_Users')
drop database GeoTema_Users
go
create database Geotema_Users
go
use Geotema_Users
create role AdminRole
grant alter any role to AdminRole with grant option
grant alter any user,select, insert, update on database::GeoTema_Users to AdminRole with grant option
create role UserRole
grant select, update on database::GeoTema_users to UserRole
go

create table Users
(
ID int identity(1,1),
Username nvarchar(20) unique,
Password nvarchar(20),
Usertype nvarchar(20)
)

insert into Users values
('Admin1','AdminPas5','administrator'),
('Super1','SuperPas5','super user'),
('User1','UserPas5','user')