sqlserver给指定用户授权访问指定表

---创建视图
CREATE VIEW [dbo].[View_RunningData]
AS
SELECT     TOP (100) PERCENT a.areaorganize, c.F_FullName AS areaorganizeName, a.recorddate, d.F_ItemCode, d.F_ItemName, a.value
FROM         dbo.ITEM_RECORD AS a LEFT OUTER JOIN
                      dbo.Sys_Organize AS c ON a.areaorganize = c.F_Id LEFT OUTER JOIN
                      dbo.Sys_ItemsDetail AS d ON a.itemid = d.F_Id LEFT OUTER JOIN
                      dbo.Sys_Items AS e ON d.F_ItemId = e.F_Id LEFT OUTER JOIN
                      dbo.Sys_Items AS f ON e.F_ParentId = f.F_Id
WHERE     (f.F_EnCode = 'YXSJ')
ORDER BY a.recorddate, d.F_ItemCode

---指定指定用户授权访问指定表
exec sp_addrole 'seeview'
GRANT SELECT ON  View_RunningData TO seeview
exec sp_addlogin 'yhsjjk','yh123','DA_Dev517'
exec sp_adduser 'yhsjjk','yh123','seeview'

  exec sp_addrole 'seeview' 

   GRANT SELECT ON  View_RunningData TO seeview

    exec sp_addlogin 'yhsjjk','yh123','DA_Dev517'

  exec sp_adduser 'yhsjjk','yh123','seeview'