Oracle assigns a table truncate permissions

I. Create a stored procedure under INS user

Second, Mobapp user empowerment: Execute the permissions of the stored procedure

Third, the Odso_insert user executes the stored procedure, can truncate the table

View Odso_insert user-owned permissions

I. Create a stored procedure under INS user

1234567

createor replace procedure p_trun_link_odso is       sqlstr varchar2(2000);begin  sqlstr := ‘truncate table ins.tb_cablecheck_link_odso‘;  executeimmediate sqlstr;  commit;end;

Second, Mobapp user empowerment: Execute the permissions of the stored procedure

Grant execute on INS.P_TRUN_LINK_ODSO to Odso_insert;

Third, the Odso_insert user executes the stored procedure, can truncate the table

1234	begin  -- Call the procedure  ins.p_trun_link_odso;end;

View Odso_insert user-owned permissions

Oracle assigns a table truncate permissions