truncate table in a different schema
I've read that you need to grant DROP ANY TABLE priv to the user. I do this, and still can not
truncate the table UNLESS... I qualify it with the SCHEMA name .
I am running Oracle 11 Rel 1 Linux.
create user MAINT .....
grant DROP ANY TABLE TO MAINT ...
gran succeeded.
The table is in MATT schema
I create a synonym on the table
create public synonym TABLE_ONE for MATT.table1;
synonym created.
back to MAINT account --
truncate table TABLE_ONE ... ORA-00942 table or view does not exist.
BUT truncate table MATT.TABLE_ONE will truncate.
I really don't want to have to specify the schema name which is what
I thought the synonym would give me.
What else am I missing here on the privs and the truncate command?
Yes, it's dangerous, so I don't want to give MAINT dba privs, cause that will work.
but the Grant doesn't seem to be doing it either.
Thanks.