oracle 用户权限管理
上一篇 /
下一篇 2012-12-06 17:49:41
/ 个人分类：数据库
---用户管理
create user test001
identified by t123;
--赋权限
grant create session, create table,create view,create sequence
to test001;
grant create procedure to test001;
---创建角色
create role manager ;
--给角色赋权限
grant create session,create table,create view,
create sequence,create procedure
to manager;
---创建一个用户
create user test_user
identified by qwe123;
---创建一用户
create user test_user001
identified by qwe123;
----给用户赋予角色
grant manager
to test_user,test_user001;
---修改用户密码
alter user test001
identified by qwe123;
---给对象赋权限
grant select
on employees
to test001;
grant update(last_name,job_id)
on employees
to test001;
---with grant option 和 public 关键字
grant select,update(last_name,job_id)
on employees
to test_user001
with grant option;
grant delete,select
on employees
to public;
收藏
举报
TAG:
用户
Oracle
oracle
权限管理
