文档介绍:SQL Server 身份验证的登录名,登录名称自定。 CREATE LOGIN Z_2011013199 WITH PASSWORD = '2011013199' CREATE LOGIN ZX_2011013199 WITH PASSWORD = '2011013199' CREATE LOGIN ZXJ_2011013199 WITH PASSWORD = '2011013199' “ gongcheng ”数据库映射三个数据库用户,数据库用户名为 Tom , Mary 和 John ,使这三个登录名可以访问“ gongcheng ”数据库。 USE gongcheng GO CREATE USER Tom FOR LOGIN Z_2011013199 --DROP USER Tom USE gongcheng GO CREATE USER Mary FOR LOGIN ZX_2011013199 --DROP USER Mary USE gongcheng GO CREATE USER Jhon FOR LOGIN ZXJ_2011013199 --DROP USER Jhon John 创建表和视图的权限。 GRANT CREATE TABLE TO Jhon GRANT CREATE VIEW TO Jhon 连接后: 验证代码: GO CREATE SCHEMA test_schema AUTHORIZATION Jhon GO 4. 完成以下授权: (1) 把对表 S的 INSERT 权力授予用户 Tom , 并允许他再将此权限授予其他用户。 GRANT INSERT ON S TO Tom WITH GRANT OPTION 检验如下: (2) 用户 Mary 对S,P,J 三个表有 SELECT 和 INSERT 权力 GO GRANT SELECT , INSERT ON S TO Mary GRANT SELECT , INSERT ON P TO Mary GRANT SELECT , INSERT ON J TO Mary GO 检验如下: (3) 用户 Tom 对 SPJ 表有 DELETE 权力,对 QTY 字段具有 UPDATE 权力。 GO GRANT DELETE , update ( QTY ) ON SPJ TO Tom GO 检验如下: 架构的创建: 检验代码: USE gongcheng UPDATE SPJ SET QTY = QTY +2 000 DELETE FROM SPJ WHERE Sno = 'S3' OR Sno = 'S4' (4) 把对用户 Tom 授予的所有权力收回 GO REVOKE DELETE , update ( QTY ) ON SPJ FROM Tom REVOKE INSERT ON S FROM TOM GO (5) 对用户 Mary 增加 SPJ 表的 SELECT 权力。 GO GRANT SELECT ON SPJ TO Mary GO (6) 拒绝 Mary 对表 P的 INSERT 权限。 DENY INSERT ON P TO Mary student