GRANT 授予权限。
REVOKE 取消权限。
|
GRANT { ALL | statement [ ,...n ] } TO security_account [ ,...n ] |
参数：
| 参数 | 意义 |
|---|---|
| ALL | 适当的权限 |
| statement | 语句权限，参见语句列表 |
| security_account | 帐户，参见特殊帐户 |
|
GRANT { ALL [ PRIVILEGES ] | permission [ ,...n ] } { [ ( column [ ,...n ] ) ] ON { table | view } | ON { table | view } [ ( column [ ,...n ] ) ] | ON { stored_procedure | extended_procedure } | ON { user_defined_function } } TO security_account [ ,...n ] [ WITH GRANT OPTION ] [ AS { group | role } ] |
|
GRANT <permission> [ ,...n ]
ON [ OBJECT :: ][ schema_name ]. object_name [ ( column [ ,...n ] ) ] TO <database_principal> [ ,...n ] [ WITH GRANT OPTION ] [ AS <database_principal> ] |
| ALL [ PRIVILEGES ] | permission [ ( column [ ,...n ] ) ] |
|
Database_user | Database_role | Application_role | Database_user_mapped_to_Windows_User | Database_user_mapped_to_Windows_Group | Database_user_mapped_to_certificate | Database_user_mapped_to_asymmetric_key | Database_user_with_no_login |
| 参数 | 意义 |
|---|---|
| ALL | 适当的权限 |
| PRIVILEGES | 是可以包含在符合 SQL-92 标准的语句中的可选关键字 |
| permission | 权限，参见权限列表 |
| security_account | 帐户 |
| WITH GRANT OPTION | 权限可以继承 |
| AS group | |
| AS role |
|
[FIELDS
[TERMINATED BY '\t'] [[OPTIONALLY] ENCLOSED BY ''] [ESCAPED BY '\\' ] ] [LINES TERMINATED BY '\n'] |
参数：
| 参数 | 意义 |
|---|---|
| TERMINATED BY | 字段之间的间隔字符，一般为逗号，空格，制表符 |
| ENCLOSED | 字段边界字符，一般为单引号，双引号 |
| ESCAPED BY | 定义文本文件中的转义字符，一般为反斜杠 |
| LINES TERMINATED BY | 记录之间的间隔字符，一般为换行 |
| 语句 | 意义 |
|---|---|
| CREATE DATABASE | 建立数据库 |
| CREATE DEFAULT | |
| CREATE FUNCTION | 建立函数 |
| CREATE PROCEDURE | 建立存储过程 |
| CREATE RULE | 建立规则 |
| CREATE TABLE | 建立表 |
| CREATE VIEW | 建立视图 |
| BACKUP DATABASE | 备份数据库 |
| BACKUP LOG | 备份日志 |
| 帐户 | 意义 |
|---|---|
| public | 代表所有帐户 |
| guest | 代表没有帐户的用户 |
| BUILTIN | Windows NT 本地组 |
| 应用于 | 帐户 | 意义 |
|---|---|---|
| 表、列、表值函数 | SELECT | |
| 表、 | INSERT | |
| 表、 | DELETE | |
| 表、列、 | UPDATE | |
| 表、标量值函数 | REFENENCES | 引用表建立外键
引用某个对象的 WITH SCHEMABINDING 子句创建 FUNCTION 或 VIEW |
| 存储过程、标量值函数 | EXECUTE |