Re: Truncating SYS owned tables

On 10.2 Oracle also changed the way dml against aud$ internally works.

It is no longer possible to delete from aud$ using any other user than SYS. The only thing you'll get is MORE rows in aud$, not less, if you try running a delete connected as another user.

See metalink Note *388169.1 *

Stefan

On 9/23/07, Hemant K Chitale <hkchital_at_singnet.com.sg> wrote:
>
>
> O7_DICTIONARY_ACCESSIBILITY=FALSE should prevent a user
> with the "*ANY*" privilege from accessing SYS tables unless the
> privilege is explicitly granted to the user directly or through a Role.
>
> Don't try truncating SYS.AUD$ if you have auditing enabled. Run
> DELETE statements to purge Audit entries.
>
> Hemant
> At 09:32 PM Friday, Joel.Patterson_at_crowley.com wrote:
>
>
> >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).
> >
> >
>
>
> Hemant K Chitale
> http://hemantoracledba.blogspot.com
>
> "There is more to life than increasing its speed."
> Mohandas Gandhi Quotes
> : http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
=========================

Stefan P Knecht
Consultant
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht_at_trivadis.com
http://www.trivadis.com

OCP SCSA SCNA
=========================

--
http://www.freelists.org/webpage/oracle-l