• Article Type: General
• Product: Aleph
• Product Version: 18.01

Description:
I'm able to do SQL Select's OK (such as a "select count") but when I try to do:

abc50@ALEPH18> update sys00.z303 set z303_dispatch_library = 'ABFST' where z303_home_library = 'ABFST' and z303_rec_key in (select substr(z305_rec_key,1,12) from z305);

I get:

ERROR at line 1:
ORA-01031: insufficient privileges

Resolution:
In order to update a sys00 table, you need to be connected to sys00. This works:

s+ sys00

update sys00.z303 set z303_dispatch_library = 'ABFST' where z303_home_library = 'ABFST' and z303_rec_key in (select substr(z305_rec_key,1,12) from abc50.z305);

• Article last edited: 10/8/2013