3个默认的用户 sys change_on_install system manager scott tiger创建用户 create user lisi identified by lisi;系统权限 grant create session to lisi; grant create table to lisi; grant unlimited tablespace to lisi;
revoke create session from lisi; revoke create table from lisi; revoke unlimited tablespace from lisi;
grant create session to public;
select * from user_sys_privs;（用户拥有的系统权限 数据字典） dba_sys_privs(所有系统权限)
对象权限 grant select on mytable to lisi; grant all on mytable to lisi;
revoke select on mytable from lisi; revoke all on mytable from lisi;
select * from user_tab_privs;
对象权限可以控制到列 grant update(name) on mytable to lisi; grant insert(id) on mytable to lisi; select * from user_col_prvis;
注意：查询、删除不能控制到列
转载于:https://www.cnblogs.com/goodyao/archive/2009/12/12/1622704.html
