SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

administer database trigger - ora-01031

518963Jun 24 2010 — edited Jun 25 2010

hello,
I have problem with my trigger. I want change schema for users, witch logon on database. I put trigger in forms when I make new users and I now that this trigger is ok, but I get error ora-01031. I put privileges (administer database trigger)for user witch execute this trigger and I still get this error.
I heard that must by sys as sysdba but I don't think so.
any idea?

regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 22 2010

Added on Jun 24 2010

5 comments

999 views