/********************************************
Before any of the below will work you need to make
sure that the server is set to allow mixed (windows 
and Sql Server Logins.
-Right click on the server and select properties
-Click the Security Tab
-Make sure SQL Server Logins is checked.
-Click ok, you will get a warning that the changes will not
take effect until the server is stopped and restarted
-in the object window right click on the server
-choose stop
-after the service is stopped, right click again and select
start
**************************************************/


Use Master --logins are only created in Master

--create a SQL Server Login
Create login jones with password='pa$$w0rd', default_database=magazineSubscription

--switch to the database
Use MagazineSubscription

--create the schema
Create Schema Sales Authorization [dbo]

--create a user assigned to that schema
Create User usrjones for login jones with default_schema=Sales

--Grant the user select permissions
Grant SELECT on SCHEMA::Sales to usrjones

--Create an object in that schema
Create View Sales.vwCustomer
AS
Select CustLastname as [Last Name],
CustFirstName as [First Name],
CustAddress as [Address],
CustCity as [City],
CustState as [State],
CustZipCode as [Zipcode],
Custphone as [phone]
From Customer

/**********************************
Now disconnect from the server and reconnect
switch from windows authentication to sql Server
authentication and enter jones and pa$$w0rd
Open the Magazine subscription database and see
what you see
**************************************/