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

Popular posts from this blog

Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.12:test (default-test) on project.Error occurred in starting fork -

windows - Debug iNetMgr.exe unhandle exception System.Management.Automation.CmdletInvocationException -

configurationsection - activeMq-5.13.3 setup configurations for wildfly 10.0.0 -