How to create an account for database

How to create an restricted account for a database?
Here's a quick answer for that question.



USE Database_Name
CREATE LOGIN account_name
WITH PASSWORD = 'myPassword';

CREATE USER account_name FOR LOGIN account_name;
Exec sp_defaultdb @loginame='account_name ', @defdb='Database_Name'
GO

USE Database_Name

GRANT EXECUTE to account_name;
GRANT SELECT, INSERT, UPDATE, DELETE ON Administrator TO account_name
GRANT SELECT, INSERT, UPDATE, DELETE ON Applications TO account_name
GRANT SELECT, INSERT, UPDATE, DELETE ON Customer TO account_name
GRANT SELECT, INSERT, UPDATE, DELETE ON MultiApp TO account_name
GRANT SELECT, INSERT, UPDATE, DELETE ON Terminal TO account_name