Shulou(Shulou.com)05/31 Report--

This article introduces you how to grant permissions to the view in sqlserver, the content is very detailed, interested friends can refer to, I hope it can be helpful to you.

Use ECC_USER

If exists (select * from dbo.sysobjects where id = object_id (N' [dbo]. [WV_UserInfo]') and OBJECTPROPERTY (id, NabilisView') = 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

On how to assign permissions to the view in sqlserver to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.