ORA-01031: insufficient privileges when trying to drop partition
11.2.0.2
The thing I try to do:
ALTER TABLE DW.MFT_WH_MRKT_RTIO DROP PARTITION MFT_WH_MRKT_RTIO_PR_D_200806
The user have DROP ANY TABLE and ALTER ANY TABLE.
What else is required?
Note: This is done in a scritp which is automatically generated. This script worked in 10.2, but after our upgrade we get the ORA-error above.
Regards
U
The thing I try to do:
ALTER TABLE DW.MFT_WH_MRKT_RTIO DROP PARTITION MFT_WH_MRKT_RTIO_PR_D_200806
The user have DROP ANY TABLE and ALTER ANY TABLE.
What else is required?
Note: This is done in a scritp which is automatically generated. This script worked in 10.2, but after our upgrade we get the ORA-error above.
Regards
U
1