USE [master]
GO
USE [Databasename]
GO
ALTER ROLE [db_datareader] ADD MEMBER [Domainame\Username]
GO
ALTER ROLE [db_datawriter] ADD MEMBER [Domainame\Username]
GO
GRANT DELETE TO [Domainame\Username]
GO
GRANT EXECUTE TO [Domainame\Username]
GO
GRANT INSERT TO [Domainame\Username]
GO
GRANT REFERENCES TO [Domainame\Username]
GO
GRANT SELECT TO [Domainame\Username]
GO
GRANT SHOWPLAN TO [Domainame\Username]
GO
GRANT UPDATE TO [Domainame\Username]
GO
GRANT VIEW DATABASE STATE TO [Domainame\Username]
GO
GRANT VIEW DEFINITION TO [Domainame\Username]
GO