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

-- 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;

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

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

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

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