new.sql

学生信息管理系统

exec sp_addlogin 'ctfysj','gem','Gem'
exec sp_addlogin 'Student','gem','Gem'
use Gem
go
exec sp_grantdbaccess N'ctfysj'
exec sp_grantdbaccess N'Student'
exec sp_addrolemember N'db_owner', N'ctfysj'
exec sp_addrolemember N'db_datareader', N'Student'
exec sp_addrolemember N'db_denydatawriter', N'Student'