sqlserver中怎么给视图赋权限

这篇文章给大家介绍sqlserver中怎么给视图赋权限，内容非常详细，感兴趣的小伙伴们可以参考借鉴，希望对大家能有所帮助。

use ECC_USER;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WV_UserInfo]') and OBJECTPROPERTY(id, N'IsView') = 1)

drop view [dbo].[WV_UserInfo]

GO

SET QUOTED_IDENTIFIER OFF 

GO

SET ANSI_NULLS ON 

GO

CREATE VIEW dbo.WV_UserInfo

AS

SELECT t1.AccountID AS RID, t1.*, t2.Balance AS Balance, t2.LockBal AS LockBal, 

      t3.LoginID AS LoginID, t3.LoginPwd AS LoginPwd, t3.Country AS Country, 

      t3.City AS City, t3.SeatPhone AS SeatPhone, t3.DefaultPhone AS DefaultPhone,  

      t3.SMSTransType AS SMSTransType, t3.SMSPhone AS SMSPhone, 

      t3.SMSKeepDay AS SMSKeepDay, t3.HandleNum AS HandleNum, 

      t3.IsReject AS IsReject, t3.FaxTransType AS FaxTransType, 

      t3.FaxEmail AS FaxEmail, t3.FaxKeepDay AS FaxKeepDay, t3.Name AS Name, 

      t3.Description AS Description, t3.SavePWD AS SavePWD, t3.AutoLogin AS AutoLogin, 

      t3.MsgAwake AS MsgAwake, t3.AutoCall AS AutoCall, t3.HitMode AS HitMode, 

      t3.LoadSMSLog AS LoadSMSLog, t3.LoadCallLog AS LoadCallLog, 

      t3.LoadConfLog AS LoadConfLog, t3.LoadLW AS LoadLW, 

      t3.LoadOralMsg AS LoadOralMsg, t3.OralMsgSMS AS OralMsgSMS, 

      t3.OralMsgPhone AS OralMsgPhone, t3.OralMsgKeepDay AS OralMsgKeepDay, 

      t3.NoAnswerLW AS NoAnswerLW, t3.BusyLW AS BusyLW, t3.AllLW AS AllLW, 

      t3.LWSize AS LWSize, t3.LWSMS AS LWSMS, t3.LWPhone AS LWPhone, 

      t3.LWWelMode AS LWWelMode, t3.SECNumber AS SECNumber,t3.FirstPlayType as FirstPlayType,t3.CallInWake as CallInWake   

FROM dbo.UserInfo t1 INNER JOIN

      dbo.UserBalance t2 ON t1.AccountID = t2.AccountID INNER JOIN

      dbo.UserSetting t3 ON t2.AccountID = t3.AccountID

GO

SET QUOTED_IDENTIFIER OFF 

GO

SET ANSI_NULLS ON 

GO

GRANT  SELECT  ON [dbo].[WV_UserInfo]  TO [public]

GO

关于sqlserver中怎么给视图赋权限就分享到这里了，希望以上内容可以对大家有一定的帮助，可以学到更多知识。如果觉得文章不错，可以把它分享出去让更多的人看到。