SQL 为另一个模式中的表创建触发器时权限不足
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/405889/
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
Insufficient privileges when creating a trigger for a table in another schema
提问by Igor Zelaya
When I try to create a trigger in schema A for a table located in schema B, I get an ora error : insufficient privileges.
当我尝试在模式 A 中为模式 B 中的表创建触发器时，出现 ora 错误：权限不足。
What privileges do I need?
我需要什么特权？
回答by Todd
If you are creating the trigger in your schema, you'll need the CREATE TRIGGER privilege. In order to create the trigger in somebody else's schema, you'll need the CREATE ANY TRIGGER privilege.
如果您在架构中创建触发器，则需要 CREATE TRIGGER 权限。为了在其他人的模式中创建触发器，您需要 CREATE ANY TRIGGER 权限。
This resourcedoes a very good job of explaining the requirements, and contains more information about triggers (syntax, enabling, disabling, etc).
该资源很好地解释了要求，并包含有关触发器（语法、启用、禁用等）的更多信息。
