create role SamanApp
go
alter role SamanApp add member [user]
go

grant execute to samanapp
grant select to samanapp
grant insert to samanapp
grant update to samanapp
grant delete to samanapp

go

---------

create role SamanOwner
go
--alter role SamanOwner drop member [shahabi]
--go

grant execute to SamanOwner
grant select to SamanOwner
grant insert to SamanOwner
grant update to SamanOwner
grant delete to SamanOwner
go
---------------------------

create role SamanTest
go
--alter role SamanTest add member [shahabi]
go

grant execute to SamanTest
grant select to SamanTest

go