new.sql

成绩管理系统,用VC和SQL 2000开发

exec sp_addlogin 'SGteacher','123456','StuGrade'
exec sp_addlogin 'SGstudent','123','StuGrade'
use StuGrade
go
exec sp_grantdbaccess N'SGteacher'
exec sp_grantdbaccess N'SGstudent'
exec sp_addrolemember N'db_owner', N'SGteacher'
exec sp_addrolemember N'db_datareader', N'SGstudent'
exec sp_addrolemember N'db_denydatawriter', N'SGstudent'