15db.txt

the original code of the book the principle and practice in sql server 2005

--use 企业销售管理系统
/*创建两个登录账号*/
execute sp_addlogin 'hyuser1','hy123456','企业销售管理系统','english'
execute sp_addlogin 'hyuser2','hy111111','企业销售管理系统','english'
/*创建两个数据库用户*/
execute sp_grantdbaccess 'hyuser1','dbhyuser1'
execute sp_grantdbaccess 'hyuser2','dbhyuser2'
execute sp_addrole 'hyrole1' /*创建角色*/
grant select,update on 职工 to dbhyuser1,hyrole1 /*给用户赋权限*/
deny update on 职工 to dbhyuser1,hyrole1
revoke select on 仓库 to hyrole1
execute sp_addrolemember hyrole1,dbhyuser2
execute sp_addrolemember hyrole1,dbhyuser1
execute sp_droprolemember hyrole1,dbhyuser1

--execute sp_addlogin 'hyuser','hyuser123456','test','english'
--execute sp_password 'hyuser123456','123','hyuser'
--execute sp_defaultdb 'hyuser','master'
--execute sp_defaultlanguage 'hyuser','german'
--execute sp_droplogin 'hyuser'
--execute sp_droplogin 'hyuser'

create database project
on
(
  name=project_data,
  filename='d:\sql\project_data.mdf',
  size=4,
  maxsize=10,
  filegrowth=10%
)
log on
(  name=project_log,
  filename='d:\sql\project_log.mdf',
  size=4,
  maxsize=10,
  filegrowth=1
)