SQL2005 SQL statement to create a remote login account _mssql2005

Copy Code code as follows:

/* Create server login Role * *
CREATE LOGIN hnjm with password= ' hnjmxy123 '
/* Open the specified database * *
Use [job]
Go
/* CREATE DATABASE role and associate Server login role/*
CREATE USER HNJM for LOGIN HNJM
/* Assign a table to the role permissions * *
GRANT SELECT on serverattachments to HNJM
GRANT SELECT on Servercompanies to HNJM
GRANT SELECT on ServerDocument to HNJM
GRANT SELECT on Serverfrontusers to HNJM
GRANT SELECT on Serverjobpostings to HNJM
GRANT SELECT on Serverrecommendedcompanies to HNJM
GRANT SELECT on Serverrecommendedpostings to HNJM
GRANT SELECT on Servercompanyjobpostingupdate to HNJM