如何创建只读权限oracle账户
程序员文章站
2022-10-05 08:09:17
1.创建角色 CREATE ROLE SELECT_ROLE 2.给角色分配权限 grant CREATE VIEW to SELECT_ROLE; grant CREATE SYNONYM to SELECT_ROLE; grant CONNECT TO SELECT_ROLE;grant SEL ......
1.创建角色
create role select_role
2.给角色分配权限
grant create view to select_role;
grant create synonym to select_role;
grant connect to select_role;
grant select any dictionary to select_role;
grant select any table to select_role;
grant select any transaction to select_role;
grant select any sequence to select_role;
3.把角色赋予指定账户
create user user identified by user default tablespace xxx;
grant select_role to user;
4.删除角色
drop role select_role;
5.检查角色的权限
select * from dba_sys_privs where grantee='select_role'
测试权限的时候需要加上用户的对象例如
select count(*) from hr.ex_user;