Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Strange ORA_942

Re: Strange ORA_942

From: Sagaran <sagaran.kasturi_at_gmail.com>
Date: 9 Feb 2005 00:22:01 -0800
Message-ID: <1107937321.532996.118140@c13g2000cwb.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US