Hello
I would like to upgrade DLP from 15.1 to 15.7, a I ran URT to make sure env is ready, but got an error:
Start: Foreign Key Validation - 2021-12-20 12:45:34
End : Foreign Key Validation - elapsed 8.9s - PASSED
Start: Trigger Validation - 2021-12-20 12:45:43
Unexpected Triggers
Owner Table Name Trigger Name Trigger Type Triggering Event
------------------- ------------------------------ ---------------------------------------- ---------------- ------------------------
--------------------------
PROTECT CREATE_SYNONYM AFTER EVENT CREATE
PROTECT DO_GRANT AFTER EVENT CREATE
End : Trigger Validation - elapsed .21s - FAILED (2 errors, 0 warnings)
Symantec's script for creating URT Protect user was used by DB team. We also consulted this with DB and our account have sufficient permissions, see below.
And we have no idea where is the problem and how it can be remediated. Really appreciate for any help on this one.
For PROTECT User.
1. System privileges granted:
GRANTEE PRIVILEGE ADM COM INH
--------- ----------------------------- --- --- ---
PROTECT CREATE TABLE NO NO NO
PROTECT CREATE JOB NO NO NO
PROTECT ALTER SESSION NO NO NO
PROTECT CREATE TYPE NO NO NO
PROTECT CREATE OPERATOR NO NO NO
PROTECT CREATE VIEW NO NO NO
PROTECT CREATE PUBLIC SYNONYM NO NO NO
PROTECT CREATE INDEXTYPE NO NO NO
PROTECT CREATE CLUSTER NO NO NO
PROTECT CREATE PROCEDURE NO NO NO
PROTECT UNLIMITED TABLESPACE NO NO NO
PROTECT CREATE SESSION NO NO NO
PROTECT CREATE MATERIALIZED VIEW NO NO NO
PROTECT CREATE SEQUENCE NO NO NO
PROTECT CREATE TRIGGER NO NO NO
PROTECT CREATE SYNONYM NO NO NO
16 rows selected.
2. Permissions already have
GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE GRA HIE COM TYPE INH
--------- --------- --------------------------- --------- --------------- --- --- --- ----------- ---
PROTECT SYS V_$SQL_PLAN SYS SELECT NO NO NO VIEW NO
PROTECT SYS V_$SQL_PLAN_STATISTICS_ALL SYS SELECT NO NO NO VIEW NO
PROTECT SYS V_$SESSION SYS SELECT NO NO NO VIEW NO
PROTECT SYS V_$SESSION_LONGOPS SYS SELECT NO NO NO VIEW NO
PROTECT SYS V_$PARAMETER SYS SELECT NO NO NO VIEW NO
PROTECT SYS V_$DATABASE SYS SELECT NO NO NO VIEW NO
PROTECT SYS V_$INSTANCE SYS SELECT NO NO NO VIEW NO
PROTECT SYS V_$SQLAREA SYS SELECT NO NO NO VIEW NO
PROTECT SYS V_$SQL SYS SELECT NO NO NO VIEW NO
PROTECT SYS V_$VERSION SYS SELECT NO NO NO VIEW NO
PROTECT SYS DBA_SEGMENTS SYS SELECT NO NO NO VIEW NO
PROTECT SYS DBA_EXTENTS SYS SELECT NO NO NO VIEW NO
PROTECT SYS DBA_DATA_FILES SYS SELECT NO NO NO VIEW NO
PROTECT SYS DBA_TABLESPACES SYS SELECT NO NO NO VIEW NO
PROTECT SYS DBA_TEMP_FILES SYS SELECT NO NO NO VIEW NO
PROTECT SYS DBA_TEMP_FREE_SPACE SYS SELECT NO NO NO VIEW NO
PROTECT SYS DBA_REGISTRY_HISTORY SYS SELECT NO NO NO VIEW NO
PROTECT SYS DBMS_LOB SYS EXECUTE NO NO NO PACKAGE NO
PROTECT SYS DBMS_SESSION SYS EXECUTE NO NO NO PACKAGE NO
PROTECT SYS DBMS_LOCK SYS EXECUTE NO NO NO PACKAGE NO
PROTECT SYS DBMS_JOB SYS EXECUTE NO NO NO PACKAGE NO
PROTECT SYS DBMS_MONITOR SYS EXECUTE NO NO NO PACKAGE NO
PROTECT SYS DATA_PUMP_DIR SYS READ NO NO NO DIRECTORY NO
PROTECT SYS DATA_PUMP_DIR SYS WRITE NO NO NO DIRECTORY NO
PROTECT SYS DBMS_MONITOR SYS DEBUG NO NO NO PACKAGE NO
25 rows selected.