正文

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

2 分钟阅读

文章摘要

文章主要介绍如何在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]

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