Oracle only grants users the permission to access the view or table [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; create a user and specify the default tablespace, temporary tablespace, connection and resource permissions to the user 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; unlimited Table space and dialog can be created for LIMS_FSGL [SQL] grant unlimited tablespace to LIMS_FSGL; grant create session to LIMS_FSGL; GRANT the table or view selection permission 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; gr Ant 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; after setting is complete, the user LIMS_FSGL can only access the selection permission of the specified table or view!