Create a view in oracle and grant permissions to users

Oracle creates a view and opens permissions to users. To improve query efficiency, you can consider opening a view for users in other companies. www.2cto.com 1. create or replace view test_table_v as select t1, t2, t3, t4, t5 from test_table 2. create the user SQL code to access this view -- create the user Create user TEST_USER default tablespace using ZH temporary tablespace TEMP profile DEFAULT; -- Grant/Revoke role privileges grant connect to TEST_USER; 3. SQL code grant select on ga_jcxx_rk_syrk_v to test_user www.2cto.com