Hi gurus,



I am having a little problem where I have some kind of procedures where
they are managing the partition tables for me but they don't complete
because of an ORA-01031: insufficient privileges Oracle error.



The SYSTEM user own the procs and try to manage other schema's partition
tables. Explicitly SYSTEM user do have alter any table and alter any
index as well as indextype etc granted.



I used a 9.2.0.4 database. Why is the privileges still a problem? When I
executed it manually it is working fine except when it is executed in a
proc. Sample of a SQL statement.



ALTER TABLE SMS.CDR_SMS DROP PARTITION P_20040628 UPDATE GLOBAL INDEXES





Any help would be appreciated.



Regards,

Deon Bouwer



NOTE: This e-mail message is subject to the MTN Group disclaimer see http://www.mtn.co.za/default.aspx?pid=34411


Oracle LazyDBA home page