create user lisi identified by 123456 //创建用户 grant create session to lisi //授予拥有会话的权限 grant create table to lisi //授予创建表的权限 grant create unlimITed tablespace to lisi //授予无空间限制的权限 revoke create session from lisi //撤销权限 revoke create table from lisi revoke create unlimited tablespace from lisi
grant select on tab to wangwu //对表tab的查询条件授予给wangwu用户 grant all on tab to wangwu //对表tab的所有操作授予给wangwu用户 revoke select on tab from wangwu revoke all on tab from wangwu