Database Administration (MOSC)

MOSC Banner

Can we create trigger on other schema table without create any trigger privilege

edited Sep 12, 2015 10:01AM in Database Administration (MOSC) 5 commentsAnswered

Hi,

Can we create trigger on other schema table without create any trigger privilege??

We have some triggers as:

CREATE OR REPLACE TRIGGER SCHEMA1.any_trigger

   AFTER INSERT

   ON SCHEMA2.any_table

   FOR EACH ROW

DECLARE

On migrating this to new database not provided the create any trigger privilege to any schemas due to security reson.

But not able to create this type of triggers even though the object privileges are there to schema1 on schema2 objects.

Can anyone suggest on this, please??

Thanks,

Vishal.


Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center