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@xxxxxxxxx @kibeha On Tue, Sep 16, 2014 at 7:42 PM, Zelli, Brian <Brian.Zelli@xxxxxxxxxxxxxxx> 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.