SQL Server 创建用户与授权表、视图的查询

 create login [用户名] with password='[密码]', default_database=[数据库名];
 create user [用户名] for login [用户名] with default_schema=[模式名];
 use [数据库名] go grant select on [表或视图的名] to [用户名];

-- 举例如
 create login xu8 with password='abcd1234@', default_database=Sanlux_test;
 create user xu8 for login xu8 with default_schema=dbo;
 use Sanlux_test go grant select on V_AppMenu to xu8;