oracl 第二课

 

oralce分为系统权限和对象权限

created user wangwu identified by wangwu;
grant create session to wangwu;
grant create unlimited tablespace to wangwu;
create table mytable<id int>;
insert into mytable value<1>;
insert into mytable value<2>;

lisi要访问wangwu的表：
oralce里面是默认手动提交commit
首先授予lisi的查询wangwu表的权限权限：
grant select on mytable to lisi;
lisi访问wangwu的表时要在表前面加入用户名字
select * from wangwu.mytable

grant all on mytable to lisi;//把表的所有权限授予给lisi

revoke all on mytable from lisi;取消授权

对象权限：是谁拥有谁授权

grant create session to pulic;//授予给public 就是授权给

所有的用户

grant create any table to public;

select * from user_sys_privs;

set linesize 400(默认值是80)

alter table mytab add name varchar(10);

disconn断开连接

grant update(name) on mytab to lisi;

grant insert(id) on mytab to lisi;

update wangwu.mytab set name='lihuoming' where id=1;

查询增加可以控制到列，删除不能控制到列
查询控制到那个权限select* from user_col_privs;