Sqlserver 创建账号

下面是通过脚本创建账号，创建一个appuser 的账号，密码：123456，可操作的DB：TEST

赋予权限，增删改查，操作视图，存储过程。当然当前的账号要有足够的权限。

 

create login appuser with password='123456', default_database=[TEST]

use TEST
GO
create user appuser1 for login appuser with default_schema=dbo;
GRANT VIEW DEFINITION ON SCHEMA :: dbo to [appuser1]
GRANT EXEC ON SCHEMA :: dbo TO [appuser]
GRANT SELECT ON SCHEMA :: dbo TO [appuser]
GRANT UPDATE ON SCHEMA :: dbo TO [appuser]
GRANT INSERT ON SCHEMA :: dbo TO [appuser]
GRANT DELETE ON SCHEMA :: dbo TO [appuser]
GRANT ALTER ON SCHEMA :: dbo TO [appuser]
G1O