Oracle 给不同用户的某些表授予截断权限
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/38329034/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Grant truncate privilege to some tables of different user in Oracle
提问by Goutham
How to Grant truncate privilege to some tables of a different user in Oracle and same ..How we can do this in Oracle 11 g..Anyone please help on this
如何在 Oracle 中授予不同用户的某些表的截断权限和相同的......我们如何在 Oracle 11 g 中做到这一点......任何人请帮忙解决这个问题
回答by Micha? M
create a procedure that can truncate a table,
创建一个可以截断表的过程，
create or replace procedure do_truncate (tab_name IN varchar2)
as
begin
execute immediate 'truncate table '||tab_name||';';
end;
/
grant execute on do_truncate to Dave;
回答by access_granted
Formal permission is "drop any table".
正式许可是“删除任何表”。
Dangerous though.
虽然危险。
