Question

在DB2中怎么revoke用户的create table权限

Answer 1

直接revoke即可： SQL> revoke create any table,create any view,select any table,drop any table from scott;

Answer 2

REVOKE CREATETAB ON DATABASE FROM USER "XXX";