[数据库][Oracle]用户和角色权限

---  用户和角色权限
-- 创建角色 mk_clerk
create role mk_clerk;
-- 创建角色 at_clerk
create role at_clerk identified by rmb;
-- 创建角色 manager
create role manager identified by externanlly;
-- 查看角色
select * from dba_roles where role in ('MK_CLERK','AT_CLERK','MANAGER');
-- 修改角色mk_clerk的密码externanlly
alter role mk_clerk identified by externanlly;
-- 为角色at_clerk授 create session权限 select any table,create view权限
grant create session,select any table,create view to at_clerk;
-- 查看角色at_clerk的权限
select * from role_sys_privs where role = 'AT_CLERK';
-- at_clerk授予manager加上create any table权限
grant create any table,at_clerk to manager;
-- 通过dba_role_privs查看角色manager的权限
select * from dba_role_privs where grantee = 'MANAGER';

-- 创建用户clerk
create user clerk identified by clerk123;
-- 创建用户mymanager
create user mymanager identified by mymanager123;
-- 查看用户 clerk和mymanager
select * from dba_users where username in ('CLERK','MYMANAGER');
-- 删除用户clerk的AT_CLERK角色
revoke at_clerk from clerk;
-- 删除角色at_clerk
drop role at_clerk;
-- 将manager授权所有用户
grant manager to public;