文章摘要
这篇文章描述了一个数据库用户操作的场景，涉及创建名为 `hnjm` 的用户并授予其 `Gran-gral SELECT` 权限。具体来说，该用户被授予了多个表的访问权限，包括 `ServerAttachments`、`ServerCompanies`、`ServerDocument`、`ServerFrontUsers`、`ServerJobPostings`、`ServerRecommendedCompanies`、`ServerRecommendedPostings` 和 `ServerCompanyJobPostingUpdate`，这些权限允许在这些表中执行 `SELECT` 操作。
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
© 版权声明
文章版权归作者所有，未经允许请勿转载。
