oracle 给用户只访问指视图 或 表 的权限

hti

[SQL] 纯文本查看 复制代码

-- Create the user   
create user LIMS_FSGL  
  identified by "LIMS_FSGL"  
  default tablespace VGSM_DB  
  temporary tablespace TEMP2  
  profile DEFAULT;  
-- Grant/Revoke role privileges   
grant connect to LIMS_FSGL ;  
grant resource to LIMS_FSGL;  
  
grant unlimited tablespace to LIMS_FSGL;  
grant create session to LIMS_FSGL;  

[SQL] 纯文本查看 复制代码

GRANT SELECT ON VGSM.V_SAMPLE TO LIMS_FSGL;  
GRANT SELECT ON VGSM.V_SAMPLE_POINT TO LIMS_FSGL;  
grant select on vgsm.sample to lims_fsgl;  
grant select on vgsm.test to lims_fsgl;  
grant select on vgsm.result to lims_fsgl;  
grant select on vgsm.plant to lims_fsgl;  
grant select on vgsm.sample_point to lims_fsgl;  
grant select on vgsm.mlp_analysis to lims_fsgl;  
grant select on vgsm.mlp_components to lims_fsgl;  
grant select on vgsm.mlp_header to lims_fsgl;  
grant select on vgsm.mlp_level to lims_fsgl;  
grant select on vgsm.mlp_values to lims_fsgl;  
grant select on vgsm.mlp_view22 to lims_fsgl;  

创建用户并指定默认表空间、临时表空间、连接与资源的权限给用户LIMS_FSGL

[SQL] 纯文本查看 复制代码

-- Create the user   
create user LIMS_FSGL  
  identified by "LIMS_FSGL"  
  default tablespace VGSM_DB  
  temporary tablespace TEMP2  
  profile DEFAULT;  
-- Grant/Revoke role privileges   
grant connect to LIMS_FSGL ;  
grant resource to LIMS_FSGL;  

不限制表空间  及 可以创建对话  给用户LIMS_FSGL

• grant unlimited tablespace to LIMS_FSGL;  
• grant create session to LIMS_FSGL;  
  

将相应的表或视图的选择权限 给用记LIMS_FSGL

[SQL] 纯文本查看 复制代码

GRANT SELECT ON VGSM.V_SAMPLE TO LIMS_FSGL;  
GRANT SELECT ON VGSM.V_SAMPLE_POINT TO LIMS_FSGL;  
grant select on vgsm.sample to lims_fsgl;  
grant select on vgsm.test to lims_fsgl;  
grant select on vgsm.result to lims_fsgl;  
grant select on vgsm.plant to lims_fsgl;  
grant select on vgsm.sample_point to lims_fsgl;  
grant select on vgsm.mlp_analysis to lims_fsgl;  
grant select on vgsm.mlp_components to lims_fsgl;  
grant select on vgsm.mlp_header to lims_fsgl;  
grant select on vgsm.mlp_level to lims_fsgl;  
grant select on vgsm.mlp_values to lims_fsgl;  
[color=silver][backcolor=rgb(248, 248, 248)][font=Verdana, Geneva, Arial, Helvetica, sans-serif][size=9px][color=rgb(51, 51, 51)][backcolor=rgb(231, 229, 220)][font=Consolas,]grant select on vgsm.mlp_view22 to lims_fsgl; 

设置完成，也就完成了用户LIMS_FSGL

只能访问指定表或视图的选择权限！

0

找到好贴不容易，我顶你了，谢了

q789321

漏洞与补丁齐飞，蓝屏共死机一色！

cheng029

男人有冲动可能是爱你，也可能是不爱，但没有冲动肯定是不爱!

非法入侵

美女未抱身先走,常使色狼泪满襟。。。。。。

cencenhai

漏洞与补丁齐飞，蓝屏共死机一色！

jericho0702

自从我变成了狗屎,就再也没有人踩在我头上了。