创建代替触发器时权限不足错误 [英] Insufficient Privileges Error while creating a Instead of Trigger

问题描述

我有一个视图，只要该视图上有插入操作，就需要在该视图上创建一个触发器.当我尝试创建代替触发器"时，出现一条错误消息，提示我权限不足.是不是当我创建触发器时，选择特权就足够了吗?如果没有，创建此触发器所需的特权是什么.

I have a view on which i need to create a Trigger whenever there is an insert action on the view. When i try to create a Instead of Trigger, i get an error saying that i have insufficient Privileges. Isn't it that when i create a trigger, select privileges are enough? If not, what are the privileges required to create this Trigger.

谢谢

推荐答案

在您自己的架构中的表上的您自己的架构中创建触发器 或根据您自己的模式(SCHEMA)，必须具有CREATE TRIGGER 系统特权.

To create a trigger in your own schema on a table in your own schema or on your own schema (SCHEMA), you must have the CREATE TRIGGER system privilege.

http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7004.htm

这篇关于创建代替触发器时权限不足错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！