Re: Truncating SYS owned tables
- From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
- To: hkchital@xxxxxxxxxxxxxx
- Date: Sun, 23 Sep 2007 09:55:49 +0200
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@xxxxxxxxxxxxxx> 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@xxxxxxxxxxx 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
>
> --
> //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@xxxxxxxxxxxx
http://www.trivadis.com
OCP SCSA SCNA
=========================
Other related posts:
