alter table drop partition for ORA-01031: insufficient privileges
736189Apr 6 2011 — edited Apr 7 2011Hi,
select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
I am having a table in Y schema whose partition based on value needs to be dropped from X schema.
For e.g., ALTER TABLE Y.TAB_NAME DROP PARTITION FOR(4853);
I guess I have given almost all the privileges. Any thoughts?
select * from DBA_TAB_PRIVS where table_name = 'TAB_NAME' and grantee = 'X';
GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE GRANTABLE HIERARCHY
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------------------------------------- --------- --------------------- --------- ---------------------
X Y TAB_NAME Y ALTER YES NO
X Y TAB_NAME Y DELETE YES NO
X Y TAB_NAME Y INSERT YES NO
X Y TAB_NAME Y SELECT YES NO
X Y TAB_NAME Y UPDATE YES NO
X Y TAB_NAME Y INDEX YES NO
6 rows selected