Oracle authorized user access to the specified view

　　

--Create user test_user, and authorize connection, query view create user Test_user identified by Test_user;grant Connect to test_user;grant CREATE view to test_user;--Grant view references a table permission to a new user grant Select on Other_user.table1 to Test_user with the grant Option;grant select on Other_user.tab Le2 to Test_user with Grant Option;grant Select on Other_user.table3 to Test_user with Grant option;--create a phase with the new user Test_user Off view Create or replace view V_1 asselect a.*,b.*,c.* from  other_user.table1 ajoin other_user.table2 B on A.id=b.fidjoin Other_user.table3 C on b.fid=c.xid--Remove the new user's permissions to create a view revoke create view from Test_user;

A lot of detours, a record.

Oracle authorized user access to the specified view