SQL GRANT 和 REVOKE 语句授权操作示例

(1) GRANT SELECT ON 职工 TO '王明'; GRANT SELECT ON 部门 TO '王明';

REVOKE SELECT ON 职工 FROM '王明'; REVOKE SELECT ON 部门 FROM '王明';

(2) GRANT INSERT, DELETE ON 职工 TO '李勇'; GRANT INSERT, DELETE ON 部门 TO '李勇';

REVOKE INSERT, DELETE ON 职工 FROM '李勇'; REVOKE INSERT, DELETE ON 部门 FROM '李勇';

(3) GRANT SELECT ON 职工 TO PUBLIC WHERE 职工.姓名 = USER;

REVOKE SELECT ON 职工 FROM PUBLIC WHERE 职工.姓名 = USER;

(4) GRANT SELECT ON 职工 TO '刘星'; GRANT UPDATE(工资) ON 职工 TO '刘星';

REVOKE SELECT ON 职工 FROM '刘星'; REVOKE UPDATE(工资) ON 职工 FROM '刘星';

(5) GRANT ALTER ON 职工 TO '张新'; GRANT ALTER ON 部门 TO '张新';

REVOKE ALTER ON 职工 FROM '张新'; REVOKE ALTER ON 部门 FROM '张新';

(6) GRANT ALL PRIVILEGES ON 职工 TO '周平' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON 部门 TO '周平' WITH GRANT OPTION;

REVOKE ALL PRIVILEGES ON 职工 FROM '周平'; REVOKE ALL PRIVILEGES ON 部门 FROM '周平';

(7) GRANT SELECT(MAX(工资), MIN(工资), AVG(工资)) ON 职工 TO '杨兰';

REVOKE SELECT ON 职工 FROM '杨兰';