Oracle grants users the permission to access only the view or table.

Source: Internet
Author: User

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!

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.