——此文章摘自《网络游戏服务器端编程》定价
¥
特价
¥
详细>>http://track
linktech
cn/?m_id=dangdang&a_id=A
&l=
&l_type
=
width=
height=
border=
nosave>
.REVOKE语句
REVOKE语句是GRANT语句的逆语句用于收回发出的许可其语法如下
()语句许可
REVOKE {ALL | statement[n]}
FROM security_account[n]
()对象许可
REVOKE[GRANT OPTION FOR]
{ALL [PRIVILEGES] | permission[n] }
{
[ (Column[n])] ON {table | view}
| ON {table | view}[(column[n])]
| ON {stored_procedure | extended_procedure}
}
FROM security_account[n]
[CASCADE]
[AS {group | role}]
下面是一个实例打开数据库game然后对gamer角色收回author表的SELECT许可不再允许gamer角色进行数据库检索接着对三个用户收回INSERTDELETE和UPDATE许可最后收回teacher角色CREATE TABLE语句许可
USE game
GO
REVOKE SELECT
ON author
FROM gamer
GO
REVOKE INSERTDELETEUPDATE
ON author
FROM MikeHenryRonald
GO
REVOKE CREATE TABLE
FROM teacher
GO
.DENY语句
DENY语句与REVOKE语句类似但是DENY语句比REVOKE语句更进了一步DENY语句不仅将授予用户的许可收回而且禁止该用户从其他角色中继承相应的许可
()语句许可
DENY {ALL | statement[n]}
TO security_account[n]
()对象许可
DENY{ALL [PRIVILEGES] | permission[n] }
{
[ (Column[n])] ON {table | view}
| ON {table | view}[(column[n])]
| ON {stored_procedure | extended_procedure}
}
TO security_account[n]
[CASCADE]
right>[http://developcsaicn/dbms/htm>] []