create login DAV4635 with password='YourPassword';
create user DAV4635 from login DAV4635;
USE AEDIDACATED
EXEC sp_addrolemember N'db_owner', N'DAV4635'
GO
__
-- ADD AD USER
CREATE USER [dexter.soreta@aei.com]
FROM EXTERNAL PROVIDER
WITH DEFAULT_SCHEMA = dbo;
EXEC sp_addrolemember N'db_datareader', N'dexter.soreta@aei.com'