sql 2005リモートログインアカウントのsql文を作成します。

630 ワード

sql 2005 リモートログイン

 
/*         */ 
CREATE LOGIN HNJM WITH PASSWORD='hnjmxy123' 
/*       */ 
USE [job] 
GO 
/*                  */ 
CREATE USER HNJM FOR LOGIN HNJM 
/*          */ 
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