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

Home -> Community -> Mailing Lists -> Oracle-L -> Truncating SYS owned tables

Truncating SYS owned tables

From: <Joel.Patterson_at_crowley.com>
Date: Fri, 21 Sep 2007 09:32:31 -0400
Message-ID: <0684DA55864E404F8AD2E2EBDFD557DA0A0E6A@JAXMSG01.crowley.com>

I can create a table in schema 'B' and can truncate it from another schema 'A' with DROP ANY TABLE system privilege. But schema 'A' cannot truncate a table owned by SYS. (namely SYS.AUD$).

Does anyone have any info on this?

(nor can schema 'A' drop a sys owned table).

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 21 2007 - 08:32:31 CDT

Original text of this message

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