USE [master]
GO
CREATE LOGIN [rico] WITH PASSWORD=N'rico', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
USE [AdventureWorksDemo]
GO
CREATE USER [rico] FOR LOGIN [rico]
GO
USE [AdventureWorksDemo]
GO
ALTER ROLE [db_owner] ADD MEMBER [rico]
GO
