Oracle 操作权限

alter user scott account unlock; 解锁

 

-- 新建用户
create user yym identified by 123456;

-- 放开用户权限
grant connect,resource to yym;

-- 开放数据表权限
grant select on scott.java0322 to yym with grant option;

-- 查询非本用户数据表
select * from scott.java0322;

-- 撤销权限
revoke select on scoot.java0322 from yym;