Hello.
I'm trying to do the following either under a user with DBA authority or the GTSYS schema owner with ADMINISTER DATABASE TRIGGER authority.
I want the trigger to always execute the GTSYS.FAST_SLICES.set_slice_by_user package/procedure whenever anyone Logs into the Pluggable database, and I want the trigger to reside in the GTSYS schema.
CREATE OR REPLACE TRIGGER GTSYS.TRG_SETSLICE
AFTER LOGON
ON PLUGGABLE DATABASE
BEGIN
GTSYS.FAST_SLICES.set_slice_by_user;
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
/
When I run this, it gives me the: "ORA-01031 error: insufficient privileges" error and I can't figure out why.
Does anyone know why this is happening or how to make it work?
I checked that the FAST_SLICES package and set_slice_by_user objects are both there in the GTSYS schema and are valid.
Thanks.