Database Administration (MOSC)

MOSC Banner

Trigger grants

edited Jan 29, 2015 10:00AM in Database Administration (MOSC) 3 commentsAnswered

Here is my scenario:

USER1 - owns TABLE1

USER2 - owns TABLE2

I created a trigger that will insert a record into TABLE2 when a record is inserted in TABLE1. 

grant insert on USER2.TABLE2 to USER1;

when I try to enter a record in TABLE1, I get an error:

ORACLE error:  unable to insert record

What access needs to be granted so TABLE2 can have a record inserted when a record is inserted in TABLE1?

Thanks!

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