Re: Strange ORA_942

All privileges on somebody's object gives you privileges to do either DMLs, select, reference, etc but not "dropping the object". To do so you need "drop any table" system privilege granted. Moreover if the PL/SQL you are using is a stored procedure/function then you need direct privileges to be granted to you but not through a role, even to refer (like select etc). Received on Wed Feb 09 2005 - 02:22:01 CST