Re: update user

From: Kim Berg Hansen <kibeha_at_gmail.com>
Date: Tue, 16 Sep 2014 19:50:09 +0200
Message-ID: <CA+S=qd1V+rrOoz+58awCQV2zvBz-iXUub96Cqysw+sT4mBxkXA_at_mail.gmail.com>

It'd have to be something unsupported. Quote from the docs of ALTER USER statement at
http://docs.oracle.com/database/121/SQLRF/statements_4003.htm#i2058207 :

ENABLE EDITIONS This clause is not reversible.

Flashback database to return all metadata to the state before? (Probably not an option ;-)

Regards

Kim Berg Hansen

http://dspsd.blogspot.com
kibeha_at_gmail.com
_at_kibeha

On Tue, Sep 16, 2014 at 7:42 PM, Zelli, Brian <Brian.Zelli_at_roswellpark.org> wrote:

> I have a user that I accidently checked to enable editions. How do I
> change that? I found it in the dba_users view but am trying to find the
> underlying tables that holds that column. Or if there is another way to
> return it to the N state for that particular user……
>
>
>
>
>
> Brian
>
>
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.

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

Received on Tue Sep 16 2014 - 19:50:09 CEST