sql实验四.docVIP

集美大学数据库系统原理课程实验报告 课程：名称： 上机实践日期： 一、目的 二、内容use xscj exec sp_addlogin stu1,123456,xscj exec sp_addlogin stu2,123456,xscj exec sp_addlogin stu3,123456,xscj exec sp_addlogin tea2,123456,xscj exec sp_addlogin tea1,123456,xscj exec sp_addlogin pro1,123456,xscj exec sp_droplogin pro1 exec sp_addrole student exec sp_addrole teacher exec sp_addrole teachadmin exec sp_grantdbaccess stu1 exec sp_grantdbaccess stu2 exec sp_grantdbaccess stu3 exec sp_grantdbaccess tea1 exec sp_grantdbaccess tea2 exec sp_grantdbaccess pro1 exec sp_revokedbaccess stu1 exec sp_addrolemember student,stu1 exec sp_addrolememb