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博客

ORACLE用户的创建和权限管理