达梦数据库表列级权限回收

创建测试表：

SQL> create table "TEST_R" ( "ID" INT, "NAME" VARCHAR(30) );
executed successfully
used time: 8.898(ms). Execute id is 509.

创建测试用户：

SQL> create role "TEST01";
executed successfully
used time: 6.294(ms). Execute id is 508.

赋权（表TEST_R中NAME列的更新权限）:

SQL> grant UPDATE("NAME") on "TEST_R" to "TEST01";
executed successfully
used time: 8.948(ms). Execute id is 510.

权限回收：（错误示例）

SQL> revoke UPDATE("NAME") on "TEST_R" from "TEST01";
revoke UPDATE("NAME") on "TEST_R" from "TEST01";
[-5658]:Error in line: 1
REVOKE only support from the whole table or view, not by column.
used time: 0.206(ms). Execute id is 0.

权限回收：（正确示例）

SQL> revoke UPDATE on "TEST_R" from "TEST01";
executed successfully
used time: 5.637(ms). Execute id is 511.

总结：

达梦数据库中权限授予可以到列级别，但是权限回收必须按表（或者视图）级回收。