ora-01031

Oracle Trigger Permissions

I want to create a trigger owned by user A for a table that is owned by user B. What permissions must I set on B.table to avoid an ORA-01031: insufficient privileges error? ...

Oracle 10G XE on RHEL 5.3

Hello, I installed Oracle 10G XE on RHEL 5.3 . I am able to login as user oracle to the database, but am unable to do so as root. If i try to login as root using 'sys as sysdba' username i get ORA-01031: insufficient privileges The root user is part of the dba group. Any way to fix this ? Thank You edit Additional info: When logge...

'ORA-01031: insufficient privileges' error received when inserting into a View

Under the user name 'MY_ADMIN', I have successfully created a table called 'NOTIFICATIONS' and a view called 'V_NOTIFICATIONS'. On the 'V_NOTIFICATIONS' view I have successfully created a trigger and a package that takes what the user attempts to insert into the view and inserts it into the table. The 'V_NOTIFICATIONS' trigger and packag...