sql2005创建远程登录帐户的sql语句（sql2008远程连接失败更改服务）真没想到

🌐 经济型：买域名、轻量云服务器、用途：游戏网站等《腾讯云》特点：特价机便宜适合初学者用点我优惠购买

🚀 拓展型：买域名、轻量云服务器、用途：游戏网站等《阿里云》特点：中档服务器便宜域名备案事多点我优惠购买

🛡️ 稳定型：买域名、轻量云服务器、用途：游戏网站等《西部数码》特点：比上两家略贵但是稳定性超好事也少点我优惠购买

文章摘要

文章主要介绍如何在Server 2008 R2环境中创建用户HNJM，并授予其多项SELECT权限。具体操作包括使用`CREATE USER`语句设置用户密码，并通过`GRANT SELECT`命令授予HNJM对ServerAttachments、ServerCompanies、ServerDocument、ServerFrontUsers、ServerJobPostings、ServerRecommendedCompanies、ServerRecommendedPostings、ServerCompanyJobPostingUpdate和ServerRecommendedPostings等服务器对象的访问权限。这些权限设置旨在控制用户对数据库和相关数据的安全访问范围，确保系统运行的安全性和稳定性。

CREATE LOGIN HNJM WITH PASSWORD=’hnjmxy123′

USE [job]

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