1.1.1 权限管理
1.1.1.1 GRANT和REVOKE
语法格式:
GRANT
priv_type [(column_list)]
[, priv_type [(column_list)]] ...
ON [object_type] priv_level
TO user IDENTIFIED BY [[PASSWORD] [password]]
[WITH with_option ...]
object_type:
TABLE | FUNCTION | PROCEDURE
priv_level:
* | *.* | database_name.* | database_name.table_name
| table_name | database_name.routine_name
REVOKE
priv_type [(column_list)]
[, priv_type [(column_list)]] ...
ON [object_type] priv_level
FROM user
REVOKE ALL PRIVILEGES, GRANT OPTION
FROM user
1.1.1.2 权限级别
GRANT和REVOKE语句允许系统管理员处理用户权限的赋予与收回。
对于GRANT和REVOKE中的权限级别,priv_type指定为下列任一种。
权 限 |
意 义 |