EXECUTE [MASTER].[DBO].[SP_ADDLOGIN] [NEWUSER],[#NEWUSER964]EXECUTE
[MASTER].[DBO].[SP_DEFAULTDB] [NEWUSER],[master]
EXECUTE [Northwind].[DBO].[SP_GRANTDBACCESS] [NEWUSER],[Joe the NewUser]
EXECUTE [pubs].[DBO].[SP_GRANTDBACCESS] [NEWUSER],[Joe the NewUser]
EXECUTE [Northwind].[DBO].[SP_ADDROLEMEMBER] [db_accessadmin],[Joe the NewUser]
EXECUTE [pubs].[DBO].[SP_ADDROLEMEMBER] [db_owner],[Joe the NewUser]
USE [Northwind]
GRANT Select ON [Northwind].[dbo].[Categories] TO [Joe the NewUser]
GRANT Select ON [Northwind].[dbo].[Order Details] TO [Joe the NewUser]
GRANT Delete ON [Northwind].[dbo].[Customers] TO [Joe the NewUser]
GRANT Execute ON [Northwind].[dbo].[Sales by Year] TO [Joe the NewUser]
GRANT Create View TO [Joe the NewUser]