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>