Re: how to revoke access to sys.aud$ in 10G

"camnewyork" <cmercer_at_vibrant-1.com> wrote in message news:1119573698.269385.38130_at_g47g2000cwa.googlegroups.com...
> Thanks, I would imagine I will not be revoking things from public
> again. I pretty much horked the database up beyond simple repair. I
> will check the value in the database tomorrow, it is not set in the
> init file so it is defaulted.
>
> For some reason the XML types went batty when I did my little revoke
> screwup. Getting them back is not a simple task but that is a story for
> a different day......
>
>
> Carl
>

Hi,

It could be set in your SPFILE, if you're using one.

-- 

Andreas Sheriff
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer
----
"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding, if you don't eat your meat?"

If this is the first email to me,
please place NOSPAM somewhere
in the subject.