plsql - Grant truncate privilege to some tables of different user in Oracle -
how grant truncate privilege tables of different user in oracle , same ..how can in oracle 11 g..anyone please on this
create procedure can truncate table,
create or replace procedure do_truncate (tab_name in varchar2) begin execute immediate 'truncate table '||tab_name||';'; end; / grant execute on do_truncate dave;
Comments
Post a Comment