sqlserver 给视图赋权限

发布时间：2020-12-12 14:58:08 所属栏目：MsSql教程来源：网络整理

导读：? 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_

 
 
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?

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!