CREATE USER sue FOR LOGIN Susan
    WITH DEFAULT_SCHEMA = sue
GO
CREATE SCHEMA sue AUTHORIZATION sue
GO
EXEC sp_addrolemember db_datareader, sue