ORACLE用户的创建和权限管理

1  创建用户

create user u1 identified by u1

default tablespace testtbs

temporary tablespace tmp;

2  删除用户

drop user u1 cascade;

3  修改用户属性

alter user u1 identified by aaa;

alter user u1 default tablepace test;

alter user u1 temporary tablespace tmp1;

alter user u1 account lock/unlock;

4  给用户赋予权限

grant create tablespace to u1;

grant select on table1 to u1;

create execute on p_job to u1;

grant update on table1 to u1 with grant option;

grant update on table1 to public; --对表的更新权限赋予所有用户

5  回收权限

revoke create tablespace from u1;

revoke update on tab1 from u1;

revoke all on tabl1 from u1; --回收tabl1表上授予用户U1的所有权限

6  查询用户的权限

select table_name, privilege

from dba_tab_privs

where grantee='U1';

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/444614/viewspace-493993/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/444614/viewspace-493993/