示例8.sql

SQL Server数据库设计和高级查询[SQL Advance]

USE  stuDB
GO
/*--为zhangsanDBUser分配对表stuInfo的select, insert, update权限--*/
GRANT select, insert, update  ON  stuInfo  TO  zhangsanDBUser 
/*--为S26301DBUser分配建表的权限--*/
GRANT  create  table  TO  S26301DBUser