sql创建数据库角色stu,分配查询学生表、课程表、选课表的权限

-- 创建数据库角色stu

create role stu

-- 分配查询学生表、课程表、选课表的权限

GRANT SELECT ON 学生表 TOstu

GRANT SELECT ON 课程表 TOstu

GRANT SELECT ON 选课表 TOstu

1、第一题

create database ReadBook

on

(name=ReadBook_data,

filename='d:\sqlserver\readbook.mdf',

size=2,

filegrowth=1,

maxsize = 5

)

log on

(name=ReadBook_log,

filename='d:\sqlserver\readbook.ldf',

size=1,

filegrowth=1,

maxsize = 5

)

2、第二题

alter database ReadBook

add filegroup bookgroup

go

alter database ReadBook

add file

( name='book2_dat',

filename='d:\sqlserver\book2_dat',

size=5,

maxsize=50,

filegrowth=5)

3、第三题

alter database ReadBook

remove file book2_dat

4、第四题

alter database ReadBook

remove filegroup bookgroup

---