sql server 2008 出现如下错误

Question

sql server 2008 出现如下错误，怎么改呀，求各位帮忙解答一下

Answer 1

先建S表视图

create view CS_S As select dept from S where S.dept='CS';

再把视图权限给user3

grant select on Cs_S to user3; 

加油(*￣︶￣)