解锁oracle 系统用户 和权限设置

alter   user   hr   account   unlock; 

alter  user   hr   identified   by   admin;  --修改密码

GRANT   SELECT   ANY   TABLE   TO   USER1;  -- 

--Oracle中用一个用户访问其它用户的表
--给用户付权的权限
用hr登入. 
GRANT    
　　CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANY PROCEDURE,   
　　ALTER ANY TABLE, ALTER ANY PROCEDURE,   
　　DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE,   
　　SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE  
　　TO scott;  
  然后用scott登入,
select * from hr.employees

--查看用户或角色所拥有的角色 
SELECT * FROM USER_ROLE_PRIVS; 


--此用户可把此系统权限授予其他用户或角色
grant connect to SCOTT with admin option;
grant resource to SCOTT with admin option;

如授予A系统权限create session with admin option,然后A又把create session权限授予B,
但管理员收回A的create session权限时，B依然拥有create session的权限，但管理员可以显式收回B
 create session的权限，即直接revoke create session from B.

<style type="text/css">.csharpcode, .csharpcode pre { font-size: small; color: black; font-family: consolas, "Courier New", courier, monospace; background-color: #ffffff; /*white-space: pre;*/ } .csharpcode pre { margin: 0em; } .csharpcode .rem { color: #008000; } .csharpcode .kwrd { color: #0000ff; } .csharpcode .str { color: #006080; } .csharpcode .op { color: #0000c0; } .csharpcode .preproc { color: #cc6633; } .csharpcode .asp { background-color: #ffff00; } .csharpcode .html { color: #800000; } .csharpcode .attr { color: #ff0000; } .csharpcode .alt { background-color: #f4f4f4; width: 100%; margin: 0em; } .csharpcode .lnum { color: #606060; } </style>